Returns a string that is the result of concatenating two or more string values.
CONCAT ( string_value1, string_value2 [, string_valueN ] )
string_value
A string value to concatenate to the other values.
String, the length, and type of which depend on the input.
SELECT CONCAT('1',N'2');
Functions