Subject Re: [firebird-php] comparing column with constant value
Author Lutz Br├╝ckner
>>I'd like to use this construction :
>>SELECT userid, username, userid=3 isthis FROM users;
>>Is it possible to get 1 in column isthis when userid=3 ?

with Firebird 1.5 you can do

SELECT userid,
CASE WHEN (userid=3) THEN 1 ELSE NULL END AS isthis
FROM users;

web based Firebird and InterBase administration:

[Non-text portions of this message have been removed]