--测试表
create table #test(id int,description varchar(100))
insert #test select 1,'1,3,4,5'
insert #test select 2,'aa,b&c,vdfd.dsd,g<>f'
select id,description1
from #test
cross apply (select description1=cast('<x>'+replace(description,',','</x><x>')+'</x>' as XML)) C0
/*