Using Comparison Operators in Expressions

An expression is a formula that returns a value. In Monarch Classic, expressions are used to define filters and calculated fields and to perform field-based searches in the Table window.

When creating expressions in Monarch Classic you can use comparison operators. A comparison operator is used to compare two values. Monarch Classic supports the following comparison operators:

Options

 Comparison Operator Examples Equal to (=) operator Customer="Bob's Records" displays only those records in which the customer's name is "Bob's Records". [Ship date]={1/31/96} displays all records that have a January 31, 1996 ship date. Not Equal to (<>) operator Customer<>"Betty’s Music Store" displays all records in which the customer's name is not Betty’s Music Store. [Ship date]<>{01/31/1996} displays all records with a ship date other than January 31, 1996. Less than (<) operator [Ship date]<{06/01/1997} displays all records with a ship date of May 31, 1997 or earlier. Invoice amount<20000 displays all records with an invoice amount of \$19,999.99 or less. Greater than (>) operator [Ship date]>{06/01/1997} displays all records with a ship date of June 2, 1997 or later. Invoice amount>20000 displays all records with invoice amounts of \$20,000.01 or larger. Less than or Equal to (<=) operator [Ship date]<={07/01/1997} displays all records with a ship date of July 1, 1997 or earlier. Invoice amount<=15000 displays all records with an invoice amount of \$15,000 or less. Greater than or Equal to (>=) operator [Ship date]>={07/01/1997} retrieves all reports with a ship date of July 1, 1997 or later. Invoice amount>=15000 retrieves all reports with an invoice amount of \$15,000 or more.