复制以下代码在查询里执行就可以啦。

使用办法：select dbo.split(parentpath, ',', 1)

                                   (’字段|字段|字段‘,'|',取出那一段从0开始)

set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOcreate FUNCTION [dbo].[split] (@str nvarchar(4000),@code varchar(10),@no int )  RETURNS varchar(200)AS  BEGIN declare @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)  end if @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 ''END