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

How about SELECT * FROM table WHERE otherdate IS [NOT] NULL?

HTH,
Brian

Richard Hollingsworth wrote:
>
> Hi. Thanks for reading this.
>
> I need to find out if a date is NULL in SQL. 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
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================