Add a NULL test (IS NULL) predicate to an SQL statement

The NULL predicate tests for null values. The result of a NULL predicate cannot be unknown. If the value of the expression is null, the result is true. If the value is not null, the result is false. If NOT is specified, the result is reversed.

These steps are part of the larger task of adding search conditions to an SQL statement (WHERE or HAVING clause). When you complete the steps for adding a simple comparison predicate to an SQL statement, return to Add search conditions to an SQL statement (WHERE or HAVING clause).

To add a NULL test (IS NULL) predicate to an SQL statement:

  1. In the Operator list, specify the type of comparison that you want to perform:

Return to Add search conditions to an SQL statement (WHERE or HAVING clause)