Concatenate (||)

The || operator makes a string concatenation.

Syntax

expr || expr
  1. expr can be a character, numeric or date time expression.

Usage

The || operator is the concatenation operator that produces a string expression from the expression elements on both sides of the operator.

This operator has a high precedence; it can be used in parameters for function calls. The precedence of this operator is higher than LIKE and MATCHES, but less than arithmetic operators. For example, a || b + c is equivalent to (a||(b+c)).

If any of the members of a concatenation expression is NULL, the result string will be NULL.

MAIN
  DISPLAY "Length: " || LENGTH( "ab" || "cdef" )
END MAIN