SPLIT function

CREATE FUNCTION dbo.SPLIT
(	@str_in		VARCHAR(1024),
	@separator	VARCHAR(4))
RETURNS @strtable TABLE (strval	VARCHAR(100))
AS
BEGIN

DECLARE	@str_total	VARCHAR(1024),
	@strpos		INT,
	@strlen_total	INT,
	@strlen_1	INT,
	@strlen_2	INT,
	@separator_len	INT

	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