BETWEEN
| All about SELECT_SQL | The Things that Make Up this Example | To Execute this Example | Forms/Components for this Example |
Function SET189I or form S_189FI
BETWEEN operator can be used in the WHERE clause to retrieve data between specified values:
SELECT_SQL FIELDS(#EMPNO #SALARY) FROM_FILES((PSLMST)) WHERE('SALARY BETWEEN 30000 AND 60000')
BETWEEN operator can be used in the WHERE clause to retrieve data excluding values between specified values:
SELECT_SQL FIELDS(#EMPNO #SALARY) FROM_FILES((PSLMST)) WHERE('SALARY NOT BETWEEN 30000 AND 60000')
BETWEEN operator can be used in the WHERE clause to retrieve data between specified values:
SELECT_SQL FIELDS(#EMPNO #SALARY) FROM_FILES((PSLMST)) WHERE('SALARY BETWEEN 30000 AND 60000')
BETWEEN operator can be used in the WHERE clause to retrieve data excluding values between specified values:
SELECT_SQL FIELDS(#EMPNO #SALARY) FROM_FILES((PSLMST)) WHERE('SALARY NOT BETWEEN 30000 AND 60000')
| Type | Name | Code | Description |
| Function | SET189I | SET189I | SELECT_SQL - (NOT) BETWEEN |
| Form | S_189FI | S_189FI | SELECT_SQL - (NOT) BETWEEN |