Flash cards
Review the key moves
1/4
Core idea
What is the main idea behind SQL IS NOT 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, AddressIs 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;