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)