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.
[ Previous Page | Next Page | Contents | Index ]