eclare @a varchar(100) set @a='1,4,13,2' select @adeclare @i int declare @tmp varchar(100) set @tmp=@a create table #t(a varchar(10))while len(@tmp)>0 begin set @i=charindex(',',@tmp) if @i>0 begin insert into #t values(left(@tmp,@i-1)) set @tmp=right(@tmp,len(@tmp)-@i) end else begin insert into #t values(@tmp) set @tmp=null end endselect * from #t drop table #t
set @a='1,4,13,2'
select @adeclare @i int
declare @tmp varchar(100)
set @tmp=@a
create table #t(a varchar(10))while len(@tmp)>0
begin
set @i=charindex(',',@tmp)
if @i>0
begin
insert into #t values(left(@tmp,@i-1))
set @tmp=right(@tmp,len(@tmp)-@i)
end
else
begin
insert into #t values(@tmp)
set @tmp=null
end
endselect * from #t
drop table #t