NOT

LANSA

NOT
All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/Components for this Example

Function SET189D or form S_189FD

You can use the NOT operator in the WHERE clause to exclude data:


SELECT_SQL FIELDS(#EMPNO #SURNAME #ADDRESS2 #SALARY) FROM_FILES((PSLMST)) WHERE('NOT ''SEVEN HILLS.'' = ADDRESS2 AND SALARY > 30000')




TypeNameCodeDescription
FunctionSET189DSET189DSELECT_SQL - NOT
Form S_189FDS_189FDSELECT_SQL - NOT