this interesting article “Concatenating Row Values in Transact-SQL” RedGate’s SimpleTalk has a perfect example Concatenating Row Values in Transact-SQL a FOR XML PATH(‘’) trick Concatenating Row Values in Transact-SQL http://www.simple-talk.com/sql/t-sql...-transact-sql/ “Concatenating Row Values in Transact-SQL” Concatenating Row Values in Transact-SQL Concatenating Row Values in Transact-SQL Concatenating Row Values in Transact-SQL - Simple Talk http://www.simple-talk.com/sql/t-sql...-transact-sql/ Concatenating Row Values in Transact-SQL “Concatenating Row Values in Transact-SQL” concatenate row values in Transact-SQL “Concatenating Row Values in Transact-SQL” Concatenating Row Values in Transact-SQL “Concatenating Row Values in Transact-SQL” Concatenating Row Values in Transact-SQL - Simple Talk Simple Talk article Concatenating Row Values in Transact-SQL - Simple Talk String Concatenation http://www.simple-talk.com/sql/t-sql...-transact-sql/ Concatenating Row Values in Transact-SQL - Simple Talk String Concatenation Concatenating Row Values in Transact-SQL - Simple Talk Concatenating Row Values in Transact-SQL 'Concatenating Row Values in Transact-SQL'