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
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