Re: Selecting NULL date
From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: Mon, 14 Jun 1999 21:21:16 GMT
Message-ID: <gne93.34777$Fz2.4292_at_news.rdc1.az.home.com>
Date: Mon, 14 Jun 1999 21:21:16 GMT
Message-ID: <gne93.34777$Fz2.4292_at_news.rdc1.az.home.com>
You have to use IS NULL, since NULL can't equal anything.
D Huynh <remove.duchuynh_at_pacbell.net> wrote in message
news:F%d93.229$7G6.60693_at_typhoon01.swbell.net...
> What is the syntax for selecting date fields that are null. For example,
> table MyTable has columns Date1 and Date2, where Date1 ad Date2 are not
> completely populated. I want to be able to do SELECT * FROM myTable WHERE
> Mytable.Date1 > Date(1999,1,1) OR MyTable.Date1 = NULL
>
>
> TIA.
>
>
>
Received on Mon Jun 14 1999 - 23:21:16 CEST