This is one the new feature in SQL Server 2012 by which you can concatenate values.
The USP of the function is that it handle the NULL values also.
means if you are concatenating values in which null also exists then it handle those null value also means it concatenates only those values which does not have null.
Suppose I want to concatenate the column like product name, product number, color and class of Product table of adventureWorks database and it might be possible that class & color may have null value. So we don’t need to do extra care of those nullable column. We can write simple query as shown below
I hope this feature may help you somewhere in your technical life.
Thanks & Enjoy