Concatenate two or more arrays, strings, or binary values into a single value.
collection
Concatenates two string values into a single string. Non-string operands are implicitly cast to text. If either operand is NULL, the result is NULL.