SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-84
LNNVL Function
LNNVL Function
The function takes condition as an argument, and when the condition is FALSE
or NULL, it returns TRUE, or when the condition is TRUE, it returns FALSE. This
function is only supported in the WHERE clause of the query.
The condition argument is a simple condition. The condition cannot be a
compound condition containing AND, OR, or BETWEEN.
The function is logically equivalent to
if ((condition = FALSE) OR (condition = NULL))
return TRUE;
else
return FALSE;
LNNVL(condition)