Concat Function comes with SQL Server 2012. This function is used to Concatenate multiple strings.
Syntax:
CONCAT ( string_value1, string_value2, string_valueN……)
Example:

Select Concat('I ','Love ','My ','India')

Result:
I Love My India