Hi,

> I'm trying to select records in which some fields are empty
> (NULL).
> Missing tryes:
>
> 1) SELECT * FROM SPONSORS
> where PDAY = NULL
>
> 2) SELECT * FROM SPONSORS
> where PDAY = 'NULL'
>
> 3) SELECT * FROM SPONSORS
> where PDAY is NULL

If they are NULL, the (3) should work just fine.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com