THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Alexander Kuznetsov

We need an OLAP function for string concatenation

String concatenation in SQL is frequently discussed on newsgroups and blogs.

Adam Machanic recently posted a competition in string concatenation

, which was followed by

Paul Nielsen's post

There were several suggestions on Connect to implement it, such as:


SQL needs version of MySQL group_Concat function


concatenate aggregation function


However, I decided to create my own suggestion, because I think that OLAP syntax is very explicit and clear, so let us stick to it. Also when you need concatenation, you need to specify a separator as well as an order in which to concatenate, which was not addressed in the previous suggestions.

Here is my suggestion.


There is one thing I do not have a strong opinion on: what should we do if one of the strings being concatenated contains a separator. For instance, if you requested a comma-separated list, and one of your strings already contains a comma. What should you do?


Published Sunday, March 29, 2009 1:27 PM by Alexander Kuznetsov

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Alexander Kuznetsov

Alex Kuznetsov has been working with object oriented languages, mostly C# and C++, as well as with databases for more than a decade. He has worked with Sybase, SQL Server, Oracle and DB2. He regularly blogs on, mostly about database unit testing, defensive programming, and query optimization. Alex has written a book entitled "Defensive Database Programming with Transact-SQL" and several articles on and Currently he works as an agile developer.

This Blog


Privacy Statement