Small Code for 2008 SQL. )

CREATE FUNCTION dbo.fn_Split

(

@InputString VARCHAR(MAX),

@Delimiter VARCHAR(MAX)

)

RETURNS @data TABLE (

Data VARCHAR(MAX)

)

AS

BEGIN

DECLARE @DelimitierLen BIGINT = LEN(@Delimiter)

DECLARE @DelimiterCharIndex BIGINT = CHARINDEX(@Delimiter,@InputString)

WHILE (@DelimiterCharIndex > 0)

BEGIN

INSERT INTO @data VALUES (SUBSTRING(@InputString, 1, @DelimiterCharIndex - 1))

SET @InputString = SUBSTRING(@InputString, @DelimiterCharIndex + @DelimitierLen, LEN(@InputString))

SET @DelimiterCharIndex = CHARINDEX(@Delimiter, @InputString)

END

INSERT INTO @data VALUES (@InputString)

RETURN

END