IBM Books

SQL Reference

NULL Predicate

>>-expression--IS----+------+--NULL----------------------------><
                     '-NOT--'
 

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.

Examples:

PHONENO IS NULL

SALARY IS NOT NULL


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]