What is Concat Function in SQL Server?


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