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 Value2.

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.