Concatenation CCL operator manipulates character strings.
The following table describes the concatenation operator:
|
Operator
|
Purpose
|
|---|
|
||, +
|
Concatenates character strings.
|
The result of concatenating two character strings is another character string.
Concatenation where one or more operands is Null results in Null.