pattern based split string in TSQL

original post: Pattern-based split string

CREATE FUNCTION dbo.SplitStringPattern
(
 @List TEXT,
 @Pattern VARCHAR(50)
)
RETURNS @ReturnTbl TABLE (OutParam VARCHAR(20))
WITH SCHEMABINDING
AS
BEGIN
 DECLARE @LeftSplit VARCHAR(7998)
 DECLARE @SplitStart INT SET @SplitStart = 0
 DECLARE @SplitEnd INT
 SET @SplitEnd = 7998

 SET @Pattern = '%' + '[^' + RIGHT(@Pattern, LEN(@Pattern) - 1) + '%'

 DECLARE @Delimiter CHAR(1)
 SELECT @Delimiter = CHAR(MAX(Number))
 FROM dbo.Numbers
 WHERE CHAR(Number) LIKE @Pattern

 SELECT @SplitEnd = MAX(Number)
 FROM dbo.Numbers
 WHERE (SUBSTRING(@List, Number, 1) LIKE @Pattern
   OR Number = DATALENGTH(@List) + 1)
  AND Number BETWEEN @SplitStart AND @SplitEnd

 WHILE @SplitStart < DATALENGTH(@List) - 1
 BEGIN
  SET @LeftSplit = @Delimiter + SUBSTRING(@List, @SplitStart, @SplitEnd - @SplitStart) + @Delimiter

  INSERT @ReturnTbl (OutParam)
  SELECT LTRIM(RTRIM(SUBSTRING(@LeftSplit, Number + 1,
                     PATINDEX(@Pattern, SUBSTRING(@LeftSplit, Number + 1, LEN(@LeftSplit))) - 1)))
                 AS Value
  FROM   dbo.Numbers
  WHERE  Number <= LEN(@LeftSplit) - 1
   AND SUBSTRING(@LeftSplit, Number, 1) LIKE @Pattern
   AND SUBSTRING(@LeftSplit, Number + 1,
                      PATINDEX(@Pattern, SUBSTRING(@LeftSplit, Number + 1, LEN(@LeftSplit))) - 1) <> ''

  SET @SplitStart = @SplitEnd + 1
  SET @SplitEnd = @SplitEnd + 7998

  SELECT @SplitEnd = MAX(Number) + @SplitStart
  FROM dbo.Numbers
  WHERE (SUBSTRING(@List, Number + @SplitStart, 1) LIKE @Pattern
    OR Number+@SplitStart = DATALENGTH(@List) + 1)
   AND Number BETWEEN 1 AND @SplitEnd - @SplitStart
 END

 RETURN
END