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
> --------------------------------------------------------------
> -------------
> 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
