SQLIS NOT NULL Keyword
IS NOT NULL
TheIS NOT NULL command is used to test for non-empty values (NOT NULL values).
The following SQL lists all customers with a value in the "Address" field:
Example
SELECT CustomerName, ContactName, Address
FROM Customers
WHERE Address IS NOT NULL;
Try it Yourself »FROM Customers
WHERE Address IS NOT NULL;
