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