Thanks Clive,

Here's an example of what I'm talking about...

DECLARE @List nvarchar(max)

SELECT @List = IsNull(@List + ', ', '') + QuoteName(name)

FROM sys.objects

--Uncommenting the following line will return only one list item...

--ORDER...

I use this a lot also, but beware of the ORDER BY gotchya. Depending on the complexity of your query you may find that adding an ORDER BY prevents...

Really glad you raised this one Steve. Let's face it we spend most of our time trying to prevent the disaster scenario in the first place. At the...