Ingres 11.0 | Is Null Predicate

OpenSQL Reference Guide > OpenSQL Reference Guide > Elements of OpenSQL Statements > Predicates > Is Null Predicate

Was this helpful?

Is Null Predicate

The is null predicate takes the form:

IS [NOT] NULL

For example:

x IS NULL

is true if x is a null. Because you cannot test for null using the “=” comparison operator, the null predicate must be used to determine whether an expression is null.

Last modified date: 01/30/2023