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 act
0:00:00', '-00-00' or
00).
-Original Message-
From: Alan Tse [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 08:18
To: [EMAIL PROTECTED]
Subject: NULL valule
I have a date field, how do I check if it is null or
empty in sql statement.
I tried :
se
I have a date field, how do I check if it is null or
empty in sql statement.
I tried :
select *
where fDate = NULL;
and also tried
where fDate = '';
Both return nothing but actually there are records
with no value.
__
