BETWEEN

LANSA

BETWEEN
All about SELECT_SQLThe Things that Make Up this ExampleTo Execute this ExampleForms/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')




TypeNameCodeDescription
FunctionSET189ISET189ISELECT_SQL - (NOT) BETWEEN
Form S_189FIS_189FISELECT_SQL - (NOT) BETWEEN