#### 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).

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com