declare @s varchar(30)
set @s='阿,不,123,str,(**)'select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)^_^
set @s='阿,不,123,str,(**)'select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)set @s=stuff(@s,1,charindex(',',@s+','),'')
select left(@s,charindex(',',@s+',')-1)^_^
set @str = 'yy,**,kk,11,'
create table #T (strT varchar(10))
while Len(@str) > 0
begin
insert into #T
select left(@str,charindex(',',@str,1) - 1 )
set @str = stuff(@str,1,charindex(',',@str,1),'')
endselect * from #T
/*
strT
----------
yy
**
kk
11(4 row(s) affected)
*/