SPLIT function

CREATE FUNCTION dbo.SPLIT
(@str_inVARCHAR(1024),
@separatorVARCHAR(4))
RETURNS @strtable TABLE (strvalVARCHAR(100))
AS
BEGIN

DECLARE@str_totalVARCHAR(1024),
@strposINT,
@strlen_totalINT,
@strlen_1INT,
@strlen_2INT,
@separator_lenINT

SELECT@str_total = @str_in + @separator,
@strpos = 1,
@strlen_1 = CHARINDEX(@separator, @str_total, @strpos) - 1,
@strlen_2 = 0,
@separator_len = LEN(@separator)

WHILE (CHARINDEX(@separator, @str_total, @strpos) > 0)
BEGIN
INSERT INTO @strtable
VALUES (SUBSTRING(@str_total, @strpos, @strlen_1))

SELECT@strlen_2 = @strlen_1

SELECT@strpos = @strpos + @strlen_2 + @separator_len + 1
SELECT@strlen_1 = CHARINDEX(@separator, @str_total, @strpos) - @strpos
END

RETURN 

END