CONCAT() function syntax with an example in SQL Server

         CONCAT() function syntax with an example in SQL Server

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

SELECT CONCAT (1, 1) ConcatInt,
('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.
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar