Thread: Return a comma seperated string?
View Single Post
  #4 (permalink)  
Old 06-09-2006, 10:35 PM
sumeet haldankar
 
Posts: n/a
Default MS SQL answer. Re: Return a comma seperated string?
[sql]
declare @a varchar(100)
select @a = isnull(@a,'') + ',' + col from table
select substring(@a,2,len(@a))
[/sql]
Reply With Quote