Using QMF

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.