SQL Reference

CONCAT

          (1)
>>-CONCAT-------(--expression1--,--expression2--)--------------><
 

Notes:

1. || may be used as a synonym for CONCAT.

The schema is SYSIBM.

Returns the concatenation of two string arguments. The two arguments must be compatible types.

The result of the function is a string. Its length is sum of the lengths of the two arguments. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

See With the Concatenation Operator for more information.