Split String Function

CREATE FUNCTION [dbo].[fnSplitString]
(
	 @String NVARCHAR (MAX),
	 @Delimiter NVARCHAR (10)
 )
RETURNS @ValueTable TABLE
(result		NVARCHAR(MAX))

BEGIN
 DECLARE @NextString NVARCHAR(MAX)
 DECLARE @Pos INT
 DECLARE @NextPos INT
 DECLARE @CommaCheck NVARCHAR(1)
 
 --Initialize
 SET @NextString = ''
 SET @CommaCheck = RIGHT(@String,1) 
 
 --Check for trailing Comma, if not exists, INSERT
 --if (@CommaCheck <> @Delimiter )
 SET @String = @String + @Delimiter
 
 --Get position of first Comma
 SET @Pos = CHARINDEX(@Delimiter,@String)
 SET @NextPos = 1
 
 --Loop while there is still a comma in the String of levels
 WHILE (@pos <>  0)  
	 BEGIN
		SET @NextString = SUBSTRING(@String,1,@Pos - 1)

		INSERT INTO @ValueTable (result) VALUES (@NextString)

		SET @String = SUBSTRING(@String,@pos +1,LEN(@String))

		SET @NextPos = @Pos
		SET @pos  = CHARINDEX(@Delimiter,@String)
	 END
 
 RETURN
END