CONCAT() function syntax with an example in SQL Server

         CONCAT() function syntax with an example in SQL Server

Introduction: 

In my previous posts we have seen what is Transact-Sql in sql server and What are new top features of T-Sql in server. This is one of the best sql server interview Questions and answers. Watch more ASP.NET, C#.NET, Jquery, Sql Server, HTML5, HTML, CSS, JQUERY UI Interview questions from here. 

Description: 

·        As the name indicates, CONCAT () will concatenate two or more strings.

·        CONCAT ()  takes a minimum of two arguments to concatenate them, resulting to a single string.

·        In Previous versions of SQL Server, “+” is used to concatenate strings.

          Example:

SELECT CONCAT (1, 1) ConcatInt,
 CONCAT ('John', NULL, 'Doe') ConcatNull,
 CONCAT (1, SPACE (1), 'John') ConcatIntString




If you have any queries or suggestions, please feel free to ask in comments section.