This email was created by [your name] who thought you would be interested in the following Article:
"Concatenate many rows into a single text string using SQL Server 2008"
Using COALESCE function - concatenate many rows into a single text string output in SQL Server.
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!