把字符传'''PF09121000010000'',''PF0912230002000'',''PF09123000010000'''
分成如下效果:
PF09121000010000,PF0912230002000,PF09123000010000
思路如下:
while (1=1)
begin
set @v_i=charindex(''',''',ltrim(rtrim(@v_BillPfNo)))
if @v_i>0
begin
set @v_Temp=substring(ltrim(rtrim(@v_BillPfNo)),2,@v_i-2)
insert into @v_Tb select @v_Temp
set @v_BillPfNo=substring(ltrim(rtrim(@v_BillPfNo)),@v_i+2,len(ltrim(rtrim(@v_BillPfNo)))-@v_i-1)
CONTINUE
end else
begin
insert into @v_Tb select substring(@v_BillPfNo,2,len(@v_BillPfNo)-2)
break
end
end