Okay, maybe this is lame, but when I've been away from writing SQL database queries for a while I can never remember how to search for database table fields that are either NULL, or NOT NULL. I always try to use the
= operator or something else.
So, for you Al, here's how to perform a SQL query and find all records where a field in a database table is NULL:
SELECT * FROM foo WHERE bar IS NULL;
And here's how to perform a SQL query showing all records in a database table where a field is NOT NULL: