Usage and Examples of SQL IS NOT NULL Keyword

SQL Keyword Reference

IS NOT NULL

The IS NOT NULL command is used to test for non-null values (NOT NULL values).

The following SQL lists all customers who have a value in the "Address" field:

SELECT CustomerName, ContactName, Address
FROM Customers
WHERE Address IS NOT NULL;

SQL Keyword Reference