LNNVL evaluates 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,
OR conditions are not valid but would otherwise be required to account for potential nulls.
NOTE: This function returns
1 (true) if the condition is false or unknown, and
0 (false) if the condition is true.
condition can be any expression containing scalar values.
LNNVL(1 > 4) returns