CONCAT

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 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