between

Type
Comparison Operator

Purpose
The between operator is used to indicate that a value falls within a specified range. It specifies that the test value is greater than or equal to Value 1 and less than or equal to Value 2.

Syntax
TEST VALUE between VALUE 1 to VALUE 2

Returns
All records for which the comparison is true.

Example
for MEMBERS with TOTAL DUE between 0 to 499 ;
list records
LAST NAME ;
MEMBER ID .
end
This statement selects MEMBERS records that have a value between 0 and 499 (inclusive) in the TOTAL DUE field.