SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-90
Examples of LNNVL
Examples of LNNVL
create table tab1(colA int, colB int, colC int);
--- SQL operation complete.
insert into tab1(colA,colB) values(100,20);
-- 1 row(s) inserted.
insert into tab1 values(200,15,8);
--- 1 row(s) inserted.
insert into tab1 values(300,8,12);
-- 1 row(s) inserted.
insert into tab1 values(400,10,11);
--- 1 row(s) inserted.
insert into tab1 values(300,10,8);
--- 1 row(s) inserted.
insert into tab1 values(300,10,6);
-- 1 row(s) inserted.
Select * from tab1 where LNNVL(colB<=colC);
COLA COLB COLC
----------- ----------- -----------
100 20 ?
200 15 8
300 10 8
300 10 6
--- 4 row(s) selected.