Searching for NULL

[admin]

When searching for NULL fields you cannot use "=". Instead, you use either "IS" or "IS NOT"...

SQL = "Select * From Customers Where Zip IS NULL"

Or...

SQL = "Select * From Customers Where Zip IS NOT NULL"