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.