The IS NULL operator is used to test for empty values (NULL values).
The following SQL lists all customers with a NULL value in the "Address" field:
Example
SELECT CustomerName, ContactName, Address
FROM Customers
WHERE Address IS NULL;
FROM Customers
WHERE Address IS NULL;
Tip: Always use IS NULL to look for NULL values.
Practice Excercise Practice now