Concatenate operator &

The concatenate operator & returns a text value that is the concatenation of its left-hand and right-hand operands.


If an operand is not a text value, the function ToText is automatically used to convert it to text before concatenating.

If one operand is null, the result will be null.