You were close Grant. You need 'IS NULL', not '=NULL'
SELECT *
FROM SomeTable
WHERE DataCompleted IS NULL
Kerry S
--- Grant Black <[EMAIL PROTECTED]> wrote:
> SELECT *
> FROM SomeTable
> WHERE DataCompleted = NULL
>
> Grant Black
> Software Developer
> SmartMove (NZ) Ltd
> Phone: +64 9 361-0219 extn 719
> Fax : +64 9 361-0211
> Email: [EMAIL PROTECTED]
>
>
> > -----Original Message-----
> > From: Darren J Gilbertson [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 18, 1999 2:47 PM
> > To: Multiple recipients of list database
> > Subject: [DUG-DB]: Filtering blank Dates
> >
> >
> > How can I select records in a SQL which filters on blank (or
> > null) dates?
> >
> > SELECT * FROM TABLE
> > WHERE datecompleted=''
> >
> > or
> >
> > SELECT * FROM TABLE
> > WHERE datecompleted<'1/1/50'
> >
> > will not work.
> >
> >
> > Darren
===
Cheers,
Kerry S
-- Systems Engineer, Inprise NZ. [EMAIL PROTECTED]
_______________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com.au address at http://mail.yahoo.com.au
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
