The IS NULL condition is satisfied if the column contains a NULL value. If you use the IS NOT NULL operator, the condition is satisfied when the column contains a value that is not NULL. This example shows an IS NULL condition:
WHERE paid_date IS NULL
Conditions that use the IS NULL operator are exceptions to the usual rule that SQL expressions in which an operator has a NULL operand return FALSE.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]