Sqlserver存储过程、函数中 字符串分割并提取第n个值

ALTER FUNCTION [dbo].[Fun_split]
(
@Str NVARCHAR(MAX),
@s NVARCHAR(2),
@i int
)
RETURNS NVARCHAR(MAX)
AS
BEGIN
  
	DECLARE @Start INT;
    DECLARE @End INT;
	DECLARE @ttt int = 1;
	DECLARE @sp NVARCHAR(MAX);
	
	set @Start=1;
	set @End=PATINDEX('%'+@s+'%',@Str);
	if PATINDEX('%'+@s,@Str)=0
	BEGIN
	   set @Str=@Str+@s;
	END
	while (@ttt <=@i and @End>0)
	BEGIN
	
	        set @sp=SUBSTRING(@Str, @Start, @End-1);
			set @ttt=@ttt+1;
			set @Start= @Start + @End;
			set @End=PATINDEX('%'+@s+'%',substring(@Str,@Start,LEN(@Str) - @Start+1));
			
	end	
	if @ttt-1<>@i 
	BEGIN
	   set @sp=null;
	end
	RETURN @sp;
END