HP Intelligent Management Center Standard Software Platform - Manual (Page 200)

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.).
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
200 Crystal Reports 2008 SP3 User's Guide
Record Selection 9
Using formula templates