is_null_predicate

version 11

arithmetic_expression IS [NOT] NULL

An is_null_predicate is used to find an arithmetic_expression with a NULL value. You can also pass the NOT keyword to find those without NULL values.

This example selects products whose weight is less than 15 or whose Color column contains a NULL value:

   SELECT Name, Weight, Color
    FROM PRODUCTS
    WHERE Weight < 15.00 OR Color IS NULL

arithmetic_expression, predicate.