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

In this case, the field is a DATE type. How can I write
the 'select' to do this?

Thanks,

Moacir