Selecting records using numbers

Single values

{file.FIELD} > 99999

Selects those records in which the value in the {file.FIELD} field is greater than 99999.

{file.FIELD} < 99999

Selects those records in which the value in the {file.FIELD} field is less than 99999.

Range of values

{file.FIELD} > 11111 and {file.FIELD} < 99999

Selects those records in which the value in the {file.FIELD} field is greater than 11111 but less than 99999 (neither 11111 or 99999 is included in the range of values).

{file.FIELD} >= 11111 and
{file.FIELD} <= 99999
Selects those records in which the value in the {file.FIELD} field is greater than 11111 but less than 99999 (both 11111 and 99999 are included in the range of values).