Nice Job Lynn, tried to solve it myself, and I couldn't get to group them. I've seen you use the FOR XML a few times in other posts.

I got a question though, why do you use stuff at the end, wouldn't a substring function, or a right function be easier?

And oh, yeah.. when I use FOR XML on a simply column, it does not give the same output. i.e: (ColA)Test1(/ColA)(ColA)TEst2(/ColA) why does appending a string to it stop doing the ColA thing?

Thanks