[sqlite] correct syntax for CASE...

[Puneet Kishor]

I am getting seriously hassled trying to do the following simple 
thing...

SELECT
        (CASE
          WHEN
            c.firstname ISNULL AND c.lastname ISNULL
          THEN
            'unnamed'
          ELSE
            c.firstname & ' ' & c.lastname
        END) AS fullname,
FROM contacts c
any advice on where I am being dense reading the docs?

ps. Would be nice to have examples of sytax, esp. expr syntax, in the 
docs.

;-)

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]