SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO--DEClARE @str varchar(500)='a,b2,v5,d3,ew,2,3,dd'--select  [dbo].[split](@str,',',8)CREATE FUNCTION [dbo].[split](@str nvarchar(4000),@code varchar(10),@no int )  RETURNS varchar(200)AS  BEGINdeclare @intLen intdeclare @count intdeclare @indexb  intdeclare @indexe  intset @intLen=len(@code)set @count=0set @indexb=1if @no=0  if charindex(@code,@str,@indexb)<>0     return left(@str,charindex(@code,@str,@indexb)-1)  else     return @strwhile charindex(@code,@str,@indexb)<>0  begin       set @count=@count+1       if @count=@no         break       set @indexb=@intLen+charindex(@code,@str,@indexb)  endif @count=@no  begin      set @indexe=@intLen+charindex(@code,@str,@indexb)          if charindex(@code,@str,@indexe)<>0             return substring(@str,charindex(@code,@str,@indexb)+len(@code),charindex(@code,@str,@indexe)-charindex(@code,@str,@indexb)-len(@code))          else             return right(@str,len(@str)-charindex(@code,@str,@indexb)-len(@code)+1)  endreturn NULLEND--select dbo.split("列名",',',0)