CONCAT#

Returns a string that is the result of concatenating two or more string values.

Syntax#

CONCAT ( string_value1, string_value2 [, string_valueN ] )

Arguments#

string_value

A string value to concatenate to the other values.

Return types#

String, the length, and type of which depend on the input.

Example#

SELECT CONCAT('1',N'2');

See Also#