Hi,

Is it possible to translate the following SQL to work with Firebird ?

SELECT ID, CASE WHEN ID2 IS NULL THEN 1 WHEN ID3 IS NULL THEN 2 END
AS IDN FROM TABLE

Firebird doesn't understand the case when.

Thanks in advance.