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
What is Concat Function in SQL Server?
Posted on June 5th, 2015 by Hitesh Kumar | 503 Views