SQL IS NULL Keyword

Flash cards

Review the key moves

1/4

Core idea

What is the main idea behind SQL IS NULL Keyword?

Lesson checks

Practice each idea before moving on

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

2Fill blank

Complete the missing token from the example code.

___ CustomerName, ContactName, Address

Is Null

The IS NULL command is used to test for empty values (NULL values).

The following SQL lists all customers with a NULL value in the "Address" field:

Example

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

Note

A NULL value is different from a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation!

Tip

Always use IS NULL to look for NULL values.

SQL INSERT INTO SELECT Keyword

SQL IS NOT NULL Keyword

Loading lesson path

Learn/SQL/SQL References

SQL•SQL References