At 11:51 AM 20/10/2003 +0000, you wrote:

>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.

What version of Firebird are you using?

heLen