NOT
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/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')
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')
| Type | Name | Code | Description |
| Function | SET189D | SET189D | SELECT_SQL - NOT |
| Form | S_189FD | S_189FD | SELECT_SQL - NOT |