Reference Guide
>
TDV Support for SQL Operators
>
Arithmetic Operators
>
Concatenation
Concatenation
The concatenation operator ( || ) concatenates the first operand and second operand and returns the combined operands.
Syntax
operand1 || operand2
Example
abc || def
This concatenation returns abcdef.