IN
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example |
Function SET189J or form S_189FJ
You can use IN to retrieve fields that match listed values:
SELECT_SQL FIELDS(#EMPNO #SKILCODE) FROM_FILES((PSLSKL)) WHERE('SKILCODE IN (''4GL'', ''INTRO'')')
Or to exclude fields that match selected values:
SELECT_SQL FIELDS(#EMPNO #SKILCODE) FROM_FILES((PSLSKL)) WHERE('SKILCODE NOT IN (''4GL'', ''INTRO'')');
You can use IN to retrieve fields that match listed values:
SELECT_SQL FIELDS(#EMPNO #SKILCODE) FROM_FILES((PSLSKL)) WHERE('SKILCODE IN (''4GL'', ''INTRO'')')
Or to exclude fields that match selected values:
SELECT_SQL FIELDS(#EMPNO #SKILCODE) FROM_FILES((PSLSKL)) WHERE('SKILCODE NOT IN (''4GL'', ''INTRO'')');
| Type | Name | Code | Description |
| Function | SET189J | SET189J | SELECT_SQL - (NOT) IN |
| Form | S_189FJ | S_189FJ | SELECT_SQL - (NOT) IN |