It depends on which backend you are working with.
With SQL Server
SELECT last_name,first_name FROM mytable WHERE date= {190-01-01}
With Oracle
SELECT last_name,first_name FROM mytable WHERE date = null
Bye
Jayesh
>Can anyone tell me how to check for a blank date in a table using the following syntax... {d 'yyyy-mm-dd'} ... and no I can't use EMPTY() because it is an Informix database that I'm using SQL Pass Thru to access.
>
>For example:
>
>This works great...
>
>SELECT last_name,first_name FROM mytable WHERE date={d '1998-08-13'}
>
>What I need is all the records that don't have a populated "date" field.
>
>Thanks in advance!
- Jayesh