SqlServer Split Function

SELECT * FROM udf_split('Naveen|Ravi','|') 

----------------------------------------------------------------------------------------------------------------------

CREATE Function [dbo].[Udf_Split]

(

    @string VARCHAR(MAX),

    @delimiter CHAR(1)

)

RETURNS @output TABLE(Id Int,Value VARCHAR(max))

BEGIN

    DECLARE @start INT, @end INT,@i INT

    SELECT @start = 1, @end = CHARINDEX(@delimiter, @string)

    Set @i=1 

    WHILE @start < LEN(@string) + 1 

    BEGIN

        IF @end = 0 

            SET @end = LEN(@string) + 1

        INSERT INTO @output (Id,Value) 

        VALUES(@i,SUBSTRING(@string, @start, @end - @start))

        SET @start = @end + 1

        SET @end = CHARINDEX(@delimiter, @string, @start)

        Set @i=@i+1  

    END

    RETURN

END