A variation of the standard concatenate operator is supported for joining two or more character or byte expressions together, generating the SQL: expression1 || expression2 ||…|| expression_n. Numeric or date expressions are converted to characters before concatenating. The resulting type, one of the character or byte data types, depends on the type of the expressions. For more concatenation operator information including argument types and rules, see Teradata® Database SQL Functions, Operators, Expressions, and Predicates, B035-1145. When dragging a Concatenate All operator into a variable, the following tree element is created.
Columns and/or other expressions can be moved into the (empty) branches of the tree, where the first argument is to the left of the concatenation operator, the second to the right, etc. In the example below, letters ‘A’, ‘B’ and ‘C’ are concatenated together to yield the SQL 'A' || 'B' || 'C', which displays as ‘ABC’.
There are no special properties for the Concatenate All operator.