That doesn´t work.
The result of : (case when f1 then ', ' else '' end)
is allways ''
- Original Message -
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite" <sqlite-users@sqlite.org>
Sent: Monday, November 27, 2006 6:00 AM
Subject: [sqlit
Daniel Schumann <[EMAIL PROTECTED]> wrote:
what do i have to do if i want to add another string after F1 if F2
is not
null e.g. ' ,' ?
select
ifnull(f1, '') ||
(case when f1 and f2 then ', ' else '' end) ||
ifnull(f2,'')
Igor Tandetnik
2 matches
Mail list logo