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