Función “Split” en TSQL (Microsoft SQL)

CREATE FUNCTION [dbo].[fn_split]
(
    @textInfo nvarchar(MAX),
    @delimiter NCHAR(1)
)
RETURNS @textRow TABLE (POSITION INT,  part nvarchar(MAX) )
AS
BEGIN
    IF @textInfo IS NULL RETURN
    DECLARE	@iStart INT,
    		@iPos INT,
			@iRow INT
 
	SET @iRow = 0
 
    IF SUBSTRING( @textInfo, 1, 1 ) = @delimiter 
    BEGIN
    	SET	@iStart = 2
    	INSERT INTO @textRow
    	VALUES( @iRow, NULL )
    END
    ELSE 
	BEGIN
    	SET	@iStart = 1
	END
 
    while 1=1
    BEGIN
		SET @iRow = @iRow + 1
    	SET	@iPos = charindex( @delimiter, @textInfo, @iStart )
 
		IF @iPos = 0
    		SET	@iPos = len( @textInfo )+1
 
    	IF @iPos - @iStart > 0			
    		INSERT INTO @textRow
    			VALUES	(@iRow, SUBSTRING( @textInfo, @iStart, @iPos-@iStart ))
    	ELSE
    		INSERT INTO @textRow
    			VALUES(@iRow, NULL )
    	SET	@iStart = @iPos+1
    	IF @iStart > len( @textInfo ) 
    		break
    END
    RETURN
 
END

DECLARE @mainTextRow TABLE (POSITION INT,  part nvarchar(MAX) )
 
INSERT INTO @mainTextRow 
		SELECT * FROM dbo.[fn_split](@fileTxt,'\n')
 
SELECT * FROM @textRow WHERE POSITION = 3