AntDB-Oracle Compatibility Developer’s Manual P3–68

LNNVL

The LNNVL function determines whether one or both operands in a condition are NULL. This function can be used in a WHERE clause or as a WHEN condition in a CASE expression. With the condition as an argument, it returns TRUE if the condition is FALSE or UNKNOWN, or FALSE if the condition is TRUE.

LNNVL(condition)

Example:

select lnnvl(math = 100) from test; LNNVL(MATH = 100) ----------------------------------- t t f t (4 rows)