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:
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?