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.

Intellectual Property Rights Notice | Technical Support