SQL•SQL References

SQL IS NOT NULL Keyword

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:

Example

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

Loading lesson path

SQL•SQL References

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:

Example

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