Subject Re: [firebird-support] Query : Numeric NULL value in where clause - usage?
Author Helen Borrie
At 06:57 AM 23/09/2004 -0700, you wrote:

>Please do help me , how to handle numeric NULL value
>in where clause.

Sometimes you will learn from reading others' threads!!

NULL IS A STATE, NOT A VALUE.

select * from A3
where DATA IN(2,1)
OR DATA IS NULL;

./heLen