CONCATReturns the concatenation of two values. Equivalent to the `&` operator.
Sample Usage
CONCAT(“de”,”mystify”)
CONCAT(17,76)
Syntax
CONCAT(value1, value2)
value1 – The value to which value2 will be appended.
value2 – The value to append to value1.
Notes
value1 and value2 can be any scalar value or reference to a scalar value, including numeric and text types.
Examples