Hi,

At October 20, 2003, 08:12, vanhuysep wrote:

> I have the following SQL working with other DB :

> SELECT ID, CASE WHEN ID2 IS NOT NULL THEN 1 WHEN ID3 IS NOT NULL THEN
> 0 END AS II FROM TABLE WHERE ID = 1

> Firebird does not understand CASE WHEN.
> What is the syntax with Firebird ?
> If it doesn't exist, is it possible to translate into Firebird SQL ?

It has been implemented in Firebird 1.5.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)