This script will give you a comma separated (or semicolon separated) list in SQL Server 2005. In other words, if you have a table with data like this:
item1 item2 item3
This code with give you:
item1, item2, item3