<< Click to Display Table of Contents >> Navigation:  Local SQL > Data Manipulation Language > Predicates > IS NULL predicate

Indicates whether a column contains a NULL value.

column_reference IS [NOT] NULL

Description

Use the IS NULL comparison predicate to filter a table based on the specified column containing a NULL (empty) value.

SELECT *

FROM Customer

WHERE (InvoiceDate IS NULL)

Use NOT to return the converse of a IS NULL comparison.

Note: For a numeric column, a zero value is not the same as a NULL value.