User`s guide

Selects those records in which the value in the {file.FIELD} field does not begin with the character "C"
(includes values like Bob's Bikes Ltd. and Feel Great Bikes, Inc.; excludes values like CyclePath, Corp.
and Cyclist's Trail Co.).
"999" in {file.FIELD}[3 to 5]
Selects those records in which the 3rd through 5th digits of the {file.FIELD} field is equal to "999"
(includes values like 10999, 70999, and 00999; excludes values like 99901 and 19990).
"Cycle" in {file.FIELD}
Selects those records in which the value in the {file.FIELD} field contains the string "Cycle" (includes
values such as CyclePath Corp. and CycleSporin, Inc.; excludes values like Cyclist's Trail Co. and Feel
Great Bikes, Inc.).
7.2.1.2 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).
7.2.1.3 Selecting records using dates
The Month, Day, and Year functions can all be used in examples like the following:
Year ({file.DATE}) < 1999
Selects those records in which the year found in the {file.DATE} field is earlier than 1999.
Year ({file.DATE}) > 1992 and Year ({file.DATE}) < 1996
2012-03-14135
Record Selection