SQL Query for empty string

[thyon]

Here is the correct query for checking for an empty field (which can be NULL):

SELECT * FROM tl_xxxx WHERE (field='' OR ISNULL(field))