Rules for concatenation
The following rules apply to using the concatenation operator:
- The operands you concatenate must all be either character strings
or graphic strings.
- The length of the result is the sum of the lengths of the operands.
- The data type of the result is:
- VARCHAR when all operands are CHAR or when one or more operands
is VARCHAR.
- VARGRAPHIC when all operands are GRAPHIC or when one or more operands
are VARGRAPHIC.
- If either operand is null, the result is the null value. (To
avoid null values, use the VALUE scalar function that is described
at page ***.)
- You cannot specify concatenation in a LIKE clause.
- You cannot specify concatenation in the SET clause of an UPDATE
query.
