Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

NULL Predicate

Description

The NULL predicate can be used for testing null values of database table columns. This predicate can be used inside of a WHERE, HAVING, or JOIN statement.

Syntax

null_predicate ::

column_name IS [ NOT ] NULL

Example

contact_name IS NOT NULL

See also:

Basic Predicate

TOCIndex