How do you find a blank date field with Local Sql

Dave Walto

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

How do you find a blank date field with Local Sql

I have a paradox table with some blank date fields in it. If I list as
follows

Select * from database where datefield<'01/01/98'
or
Select * from database where datefield>'01/01/98'

None of these list the records with the blank date fields.
What SQL can do this.

Thanks

Dave

Jerr

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How do you find a blank date field with Local Sql

or (datefieldX is null)

Dave Walton <wylam.gar...@btinternet.com> wrote in article
<6g37i5$cf...@plutonium.btinternet.com>...

Quote

> I have a paradox table with some blank date fields in it. If I list as
> follows

> Select * from database where datefield<'01/01/98'
> or
> Select * from database where datefield>'01/01/98'

> None of these list the records with the blank date fields.
> What SQL can do this.

> Thanks

> Dave

Other Threads

1. Finding blank Date Fields (SQL)

2. SQL on Blank Date Fields (Dbase/Foxpro Tables)

3. Blanking masked date fields and date-masked TEdits!

4. How to Find a Substring into a .DBF field with Local SQL

5. Query on Date field in local SQL

6. Group by months from a date field with local sql

7. Local SQL, calculated fields, difference between 2 dates

8. Local SQL, calculated fields, difference between 2 dates

9. Local SQL Empty Date Field

10. Local SQL with Date and DateTime fields