Re: How to tell if a date is NULL??

you were soooo close:

Richard Hollingsworth wrote:

> Hi. Thanks for reading this.
>
> I need to find out if a date is NULL in SQL.

where date is null ^^^^

> How do you do that?
>
> My best try do far is
>
> Select *******
> From ******
> Where SysDate - OtherDate != 0;
>
> Is there a better way?
>
> Thanks,
> RIchard Hollingsworth
Received on Thu Oct 05 2000 - 14:57:40 CDT