Equal expressions

The Equal expression returns TRUE if one of the operands are exactly equal; otherwise, FALSE is returned.

One of the following conditions must apply for the expression to return TRUE:
  • The Boolean operands are exactly equal.
  • The Integer operands are exactly equal.
  • The Date Time operands are exactly equal. When comparing two Date Time values like these, +2010-01-14T19:18:59:000+00:00-UTC and +2010-01-14T19:18:59:000-00:00-UTC, the values are equivalent because, despite the bias being different, the offsets are both set to 00:00. In addition, if the only difference between two Date Time values is the descriptive time zone, the values are also deemed equivalent. Therefore, the following two values are also equal: +2010-01-14T19:18:59:000+00:00-UTC and +2010-01-14T19:18:59:000+00:00-Pacific Time Zone
  • The String Array operands are exactly equal. Both operands must have the same number of elements. Each element in the first operand must be exactly equal to its corresponding element in the second operand.

    Here, the operator is case-sensitive. You cannot use wildcard characters.

The Equal operator has two operands. Each operand can be either a value or another expression, where the result of the expression must match the data type of the operand in the parent expression.
Table 1. Equal expression
Operator Operands Data type of return value
Equal
(Boolean, Boolean)
(Date Time, Date Time)
(Integer, Integer)
(String Array, String Array)
Boolean