Comments by MarcoBot (Top 3 by date)

First, the + operator can concatenate strings in T-SQL. But my original comment was referring to the top of the thread, where he used:

<pre>
SELECT ProductName + ','
FROM Northwind.dbo.Products
FOR XML PATH('');
</pre>

And I was wondering (basically) why he was using the 'FOR XML PATH('')' clause. And the + operator can concatenate two strings.

No, I'm using T-SQL which doesn't have +=. I just ran the query and then cut & pasted it into the comment.