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');