[DUG-DB]: Filtering blank Dates

[Darren J Gilbertson]

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