Table contents to a comma seperated, Split word by comma

SELECT STUFF(

(SELECT ‘,’ + StateName

FROM Bl_State

ORDER BY StateName

FOR XML PATH(”)),1,1,”) AS CSV

=================================================

———————————–Split word by comma

declare @s varchar(1000)

select @s = ‘a,b,cd,ef,zzz,hello,llll,mmm’

;with csvtbl(i,j)

as

(

select i=1, j=charindex(‘,’,@s+’,')

union all

select i=j+1, j=charindex(‘,’,@s+’,',j+1) from csvtbl

where charindex(‘,’,@s+’,',j+1) 0

)

select substring(@s,i,j-i)

from csvtbl

Advertisement