Null Conditions

A NULL condition tests for nulls. This is the only condition that you should use to test for nulls.

null_conditions::=
Description of null_conditions.gif follows

Table 6-9 lists the null conditions.

Table 6-9 Null Conditions

Type of Condition	Operation	Example
IS [NOT] NULL	Tests for nulls. See Also: "Nulls "	SELECT last_name FROM employees WHERE commission_pct IS NULL;