List of expression elements / Character string operators |
The || operator makes a string concatenation.
expr || expr
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