字符分割拆分妙用

把字符传'''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