Split String

CREATE FUNCTION dbo.Split
(
    @String NVARCHAR(max),
    @Delimiter VARCHAR(5)
)
RETURNS @SplittedValues TABLE
(
    id SMALLINT IDENTITY(1,1),
    item VARCHAR(200)
)
AS
BEGIN
    DECLARE @SplitLength INT
    WHILE LEN(@String) > 0
    BEGIN
        SELECT @SplitLength = (CASE CHARINDEX(@Delimiter,@String) WHEN 0 THEN
            LEN(@String) ELSE CHARINDEX(@Delimiter,@String) -1 END)
        INSERT INTO @SplittedValues
            SELECT SUBSTRING(@String,1,@SplitLength)
                SELECT @String = (CASE (LEN(@String) - @SplitLength) WHEN 0 THEN ''
                    ELSE RIGHT(@String, LEN(@String) - @SplitLength - 1) END)
    END
    RETURN
END