The analytical expressions make use of operators for creating expressions to compare values, perform arithmetic calculations, or also work with strings.

Types of Operators

There are four types of calculation operators available: arithmetic, comparison, text concatenation, and logical.

Arithmetic Operators

Use the following arithmetic operators to perform basic mathematical operations such as addition, subtraction, or multiplication; combine numbers; or produce numeric results.

Note:
1. The plus sign (+) and the minus sign (-) can both serve as a binary operator and as a unary operator.
2. The forward slash is an unsafe division. Please use the divide function for using a safe division. For more information, see Math functions article.

Comparison Operators

You can use the following operators to compare two values. While comparing two values by using the following operators, the result is always a logical value, either TRUE or FALSE.

Note: The settings of the database itself specify whether the "=" operator is case-sensitive or not.

Text concatenation operator

Use the ampersand (&) to join or concatenate two or more text strings for creating a single piece of text.

Logical operators

Use logical operators (&&) and (||) to combine expressions for creating a single result.

Note: The "IN" operator mentioned above is a function, not a binary operator.

Operator Precedence

If you combine multiple operators within a single formula, the operations are ordered according to the following table. In case the operators have equal precedence values, they are ordered from left to right. For example, if an expression contains both a multiplication and a division operator, they are evaluated in the order in which they appear in the expression, that is, from left to right.