CONCAT()

It is a new for SQL 2012, it concatenate different length string and make it a single length string.

It only used in SQL version 2012.

Syntax

CONCAT ( string_value1, string_value2 [, string_valueN ] )

 

For detail information please look at.

http://msdn.microsoft.com/en-us/library/hh231515%28SQL.110%29.aspx

 

Posted By: MR. JOYDEEP DAS