List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 26 2001 1:49am
Subject:Re: NULL valule
View as plain text  
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
Thread
NULL valuleAlan Tse26 Jul
  • RE: NULL valuleWannaDrunk®26 Jul
  • Re: NULL valulePaul DuBois26 Jul