Operators

This table shows the available operators for various categories:
Category Available operators
Text comparisons
  • lt: less than
  • le: less than or equal to
  • eq: equal to
  • ne: not equal to
  • ge: greater than or equal to
  • gt: greater than
  • ct: contains

Text operators perform string comparisons, no matter what data types are specified in the arguments.

If an operand is a date type, then both operands are converted to dates and the dates are compared.

Numeric comparisons
  • < : less than
  • <=: less than or equal to
  • ==: equal to
  • !=: not equal to
  • >=: greater than or equal to
  • >: greater than

Numeric operators expect their arguments to be numeric. Use numeric operators to compare any combination of numeric data types. When different types are compared, operands are promoted to the required type.

If both operands are integers, then an integer comparison is performed. If an operand is a floating point, then a double comparison is performed.

Logical comparisons
  • !:NOT
  • ||: OR
  • &&: AND

Comparisons can be as complex as necessary and can use parentheses to define the precedence of operations.

Other comparisons The only option is [( )] Evaluate First.

This binds compound boolean expressions, so that the evaluation happens correctly. For example:

IF (Flag eq =A||Flag eq =B) && Dept eq =L

In this example, if Flag equals A or B, and Dept is also L, then the whole statement is true.

Note: Conditionals are not validated in any way.