The following table describes how commands and functions interpret null values.
Data type | Behavior |
---|---|
Most logical expressions that evaluate to .NULL. return .NULL. or generate an error. EMPTY(В ), ISBLANK(В ), and ISNULL(В ) are exceptions. |
|
Numeric expressions that evaluate to .NULL. return .NULL. A numeric function evaluates to .NULL. when passed a null value. |
|
Date expressions containing null values return .NULL. |