Expression Builder Operators

This topic describes the operators that are available for use in the Expression Editor.

Operators

These operators represent a mathematical or logical operator that can be used in expressions.

• +

  Addition/Concatenation operator. The addition operator adds two numeric values. These values can be variables, literal numbers, or any combination thereof. The concatenation operator concatenates or joins strings and substrings into a target unit. Use the concatenation, +, operator to join string variables, literals, or any combination thereof.

• -

  Subtraction/Unary negation operator. The subtraction operator subtracts the right operand from the left operand. These values can be variables, literal numbers, or any combination thereof. The unary negation operator negates a numeric value or a variable containing a numeric value.

• *

  Multiplication operator. This operator multiplies a numeric value by another numeric value. These values can be variables, literal numbers, or any combination thereof.

• /

  Division operator. This operator divides the left operand by the right operand. These values can be variables, literal numbers, or any combination thereof.

• %

  Modulo operator. This operator provides the remainder of dividing the left operand by the right operand.

• =

  Assignment operator. This operator provides a value assignment from right to left.

• &&

  Logical AND operator. This operator returns true if the left and right sides of the operator are both true.

• ||

  Logical OR operator. This operator returns true if either the left or right sides of the operator is true.

• ==

  Equal operator. This operator returns true if the left operand is equal to the right operand.

• !=

  Not equal operator. This operator returns true if the left operand is not equal to the right operand.

• >

  Greater than operator. This operator returns true if the left operand is greater than the right operand.

• >=

  Greater than or equal operator. This operator returns true if the left operand is greater than or equal to the right operand.

• <

  Less than operator. This operator returns true if the left operand is less than the right operand.

• <=

  Less than or equal. This operator returns true if the left operand is less than or equal to the right operand.

• !

  Unary NOT operand. This operator returns true if the right side of the operator is false.

Selection Criteria Operators

Selection criteria lets you create expressions that limit the number of records processed and returned, as well as test for null values.

• BETWEEN

  This operator specifies a range to test. It will return all values between the specified values.

• LIKE

  This operator determines whether a given character string matches a specified pattern. A pattern can include regular characters and wild card characters. During pattern matching, regular characters must exactly match the characters specified in the character string. Wild card characters, however, can be matched with arbitrary fragments of the character string. Using wild card characters makes the LIKE operator more flexible than using the = and != string operators.

• IN

  This operator determines if a given value matches any value in a subquery or a list.

• IS NULL

  This operator retrieves fields with null values.

• NOT

  This operator negates the returned value.