LNNVL
The LNNVL function provides a concise way to evaluate a condition when one or both operands of the condition may be null. LNNVL can be used anywhere a scalar expression can appear, even in contexts where the IS [NOT] NULL, AND, or OR conditions are not valid but would otherwise be required to account for potential nulls.
Return Values
TRUE if the condition is false or unknown and FALSE if the condition is true.
Syntax
LNNVL(condition)
Parameters
- condition
-
An expression constructed using any scalar values. Note that you cannot specify an expression that contains AND, OR, or BETWEEN.
Examples
Example 8-12 Evaluating Expressions Using LNNVL
SHOW LNNVL('apples' EQ 'oranges')
yes
SHOW LNNVL(7 LT 11)
no
SHOW LNNVL('vegetables' EQ NA)
yes
