finding empty data in database

[masCh]

Hello

This is my second post here. This is probably one of the most helpful forums out there! =)

I have a database with perhaps the following:

ID Data
1 12/12/2005
2 5/12/2005
3
4 3/12/2005
5
6
7 1/12/2005

How do I write my SQL statement to retrieve only empty Data?

SQL="Select ID,Data From table WHERE Data='' " 'does not retrieve anything

I actually need to count how many blank data there are in the database, and response.write the corresponding ID

The problem is Data could be an empty string '', it could be null, it could be just blank, we dont know. I dont know what else it could be.

Anyone done something like this before?

[schizo]

Hello, one of two should probably work...

"SELECT ID, Data FROM table WHERE Data = ''"

-OR-

"SELECT ID, Data FROM table WHERE Data IS NULL"

Whether it is null or a blank string will depend on the column data type and wheter it is set to non-null/required.