Comparison Operators

The following Comparison Operators can be used in complex report expressions:

Numeric Comparison Operators

= - Equal to specified expression (e.g. rgcrsefee=125.00 returns a registration if the registration fee is equal to 125.00).
=> - Equal to or Greater than specified expression (e.g. rgcrsefee => 125.00 returns a registration if the registration fee is greater than or equal to 125.00).
> - Greater than specified expression (e.g. rgcrsefee > 125.00 returns a registration if the registration fee is greater than 125.00).
<= - Lesser than or Equal to specified expression (e.g. rgcrsefee <= 125.00 returns a registration if the registration fee is lesser than or equal to 125.00).
< - Lesser than specified expression (e.g. rgcrsefee < 125.00 returns a registration if the registration fee is lesser than 125.00).
<> - Not equal to specified expression (e.g. rgcrsefee <> 125.00 returns a registration if the registration fee is not equal to 125.00).

Arithmetic Operators

+ - Addition
- - Subtraction
* - Multiplication
/ - Division

Character Comparison Operators

= - Begins with specified expression (e.g. nmfirm="ACEware" returns names if the Firm field begins with ACEware).
$ - Contained within specified expression (e.g. "aceware.com" $ nmemail returns names if aceware.com is in the email address field).
== - Exactly matches specified expression (e.g. nmfirm="ACEware Systems, Inc." returns names if the firm field exactly matches ACEware Systems, Inc.).
<> - Not equal to specified expression (e.g. pytype <> '8' return a payment if the payment type is not 8 [Void]).

Notes

Character strings must be enclosed in quotation marks.
Character string comparisons are case-sensitive. If you want to return records no matter the case, you can use the UPPER() report function to upper-case the field contents for the comparison, e.g.

upper(nmfirm)="ACEWARE" returns names if the firm field begins with ACEWARE, no matter how it's actually entered in the field (ACEware, Aceware, aceware).

Logical Comparison Operators

! - Not equal to the specified expression (e.g. !rgcancel returns a registration if it is not canceled).

Note: this operator can also be used with certain report functions. For instance, the Empty() function returns a value if the specified field is empty. !Empty() will return a value if the specified field is not empty.