empty fields

[monkeymeister]

How do you specify empty fields in an SQL query? For example, I have a lot of fields in a database which aren't null but are just empty. I've tried WHERE FIELD <> "" to remove any records which have an empty field from the query results, but it doesn't work. What is the correct way to do this?


Cheers,

Mike

 

[monkeymeister]

Doh! Figured it out...should be '' for SQL instead of ""...