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: [sqlite] Re: Re: combination of fields with || ?
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
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
