Returns 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 whichvalue2
will be appended. -
value2
- The value to append tovalue1
.
Notes
value1
andvalue2
can be any scalar value or reference to a scalar value, including numeric and text types.