select * from table
where datecompleted is null
> -----Original Message-----
> From: MIME :[EMAIL PROTECTED] > Sent: Wednesday, 18 August 1999 15:12
> To: [EMAIL PROTECTED]
> 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
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Database List - > [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> > >
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
