Puneet Kishor wrote:
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
^ ^
Probably you mean the concatenate operator, which in
SQL is ||, not &. & is not an SQL operator as far as
I am aware, though SQLite uses it to mean bit-wise AND,
just like C/C++.
END) AS fullname,
FROM contacts c
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]