Splitting the string with unique delimiter.

CREATE FUNCTION dbo.FSplitColumns
(
@StringArray VARCHAR(8000),
@Delimiter VARCHAR(10)
)
RETURNS
-- The ouput has been captured in @Results table datatype
@Results TABLE
(
id INT IDENTITY(1, 1), 
Item VARCHAR(8000)
)
AS
BEGIN
DECLARE @Next INT,
@lenStringArray INT,
@lenDelimiter INT,
@i INT

SELECT  @i=1, 
@lenStringArray=LEN(@StringArray),
@lenDelimiter=LEN(@Delimiter)

WHILE @i<=@lenStringArray
BEGIN
--find the next occurrence of the delimiter in the stringarray 
SELECT @next=CHARINDEX(@Delimiter, @StringArray + @Delimiter, @i) 
INSERT INTO @Results (Item)
SELECT SUBSTRING(@StringArray, @i, @Next - @i) 
SELECT @i=@Next+@lenDelimiter 
END 
RETURN 
END