A variation of the standard Add operator is supported for adding two or more numeric expressions together, generating the SQL: expression1 + expression2 +…+ expressionN. Character expressions are automatically converted, if possible, to numbers before adding. The resulting numeric type depends on the type of the expressions. For more information, refer to the chapter titled Binary Arithmetic Result Data Types in SQL Functions, Operators, Expressions and Predicates, B035-1145.
When dragging an Add 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 plus operator, the second to the right, and so forth. In the example below, numbers 1, 2 and 3 are added together to yield the SQL 1+2+3, which displays as 6.
There are no special properties for the Add All operator.