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. |
© 2024 Altair Engineering Inc. All Rights Reserved.