The IS NOT NULL command is employed to check for non-empty values (NOT NULL values).
The following SQL enumerates all customers with a value in the “Address” field:
SELECT CustomerName, ContactName, Address FROM Customers WHERE Address IS NOT NULL; |