Re: NULL valule

[Paul DuBois]

At 10:17 AM +1000 7/26/01, Alan Tse wrote:
>I have a date field, how do I check if it is null or
>empty in sql statement.
>
>I tried :
>select *
>....
>where fDate = NULL;

Wrong test.  NULL is special.  Use:

where fDATE IS NULL

>
>and also tried
>where fDate = '';
>
>Both return nothing but actually there are records
>with no value.


-- 
Paul DuBois, paul@stripped