Here is the correct query for checking for an empty field (which can be NULL):
Code:SELECT * FROM tl_xxxx WHERE (field='' OR ISNULL(field))
Printable View
Here is the correct query for checking for an empty field (which can be NULL):
Code:SELECT * FROM tl_xxxx WHERE (field='' OR ISNULL(field))