Is there an Implode type function for SQL Server?
What I have is a list (in a SQL server table):
Apple
Orange
Pear
Blueberry
and I want them to come out as
Apple, Orange, Pear, Blueberry
I hope for the space and comma to be configurable but I can always replace it if it isn't...
Quick help would be appreciated!