GetPart Function.sql

CREATE FUNCTION [dbo].[GetPart](@inputString AS VARCHAR(MAX), @index AS int, @delimiter AS CHAR(1) = '~') RETURNS VARCHAR(MAX)
                AS
                BEGIN
	                DECLARE @ResultVar AS VARCHAR(MAX), @start INT, @end INT, @current INT
                    SELECT @start = 1, @end = CHARINDEX(@delimiter, @inputString), @current = 0 

                    WHILE @start < LEN(@inputString) + 1
	                BEGIN 
                        IF @end = 0 
                            SET @end = LEN(@inputString) + 1
       
		                IF (@index = @current)
			                RETURN SUBSTRING(@inputString, @start, @end - @start)
		                SET @current = @current + 1
                        SET @start = @end + 1 
                        SET @end = CHARINDEX(@delimiter, @inputString, @start)
	                END 
	                RETURN NULL
                END