[sql]use pubs
go
DECLARE @str NVARCHAR(4000)
-- Forming the comma separated string
SELECT @str= COALESCE(@str+',' , '') + (A.stor_name)
FROM (SELECT distinct stor_name = RTRIM(stor_name) FROM stores ) A
-- now show the string
Select @str[/sql]