Replace "=" with "IS"
SELECT *
FROM SomeTable
WHERE DataCompleted IS NULL
Cheers,
Carl Reynolds Ph: +64-9-4154790
CJN Technologies Ltd. Fax: +64-9-4154791
[EMAIL PROTECTED] DDI: +64-9-4154795
PO Box 302-278, North Harbour, Auckland, New Zealand
12 Piermark Drive, North Harbour Estate, Auckland, NZ
Visit our website at http://www.cjntech.co.nz/
> -----Original Message-----
> From: Darren J Gilbertson [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 18, 1999 3:04 PM
> To: Multiple recipients of list database
> Subject: RE: [DUG-DB]: Filtering blank Dates
>
> Thanks for the response Grant, but
>
> when I try that and open the query in design time I get:
>
> Invalid keyword NULL
>
> What is wrong.
>
>
> Darren
> ----------------------------------------------------------------------
> -----
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
application/ms-tnef
