<!--

main_leaderboard, all: [728,90][970,90][320,50][468,60]

-->

SQL IS NOT NULL Keyword

❮ SQL Keywords Reference

IS NOT NULL

The IS 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:

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

Try it Yourself »

❮ SQL Keywords Reference