[sqlite] Re: Re: combination of fields with || ?

[Igor Tandetnik]

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]
-----------------------------------------------------------------------------