Here is a snippet I found in a recently developed piece of code:

Stored proc parameter: @reportstring NVARCHAR(max)

DECLARE @tmpTbl TABLE ( value NVARCHAR(200) )

SELECT @Tmp = ''

SELECT @i = 1

SELECT @length = LEN(@reportstring)

WHILE (@i <= @length)

BEGIN

SELECT @char = SUBSTRING(@reportstring, @i, 1)

IF (@char = ',')

BEGIN

INSERT INTO @tmpTbl SELECT @Tmp

SELECT @Tmp = ''

END

ELSE

BEGIN

SELECT @Tmp = @Tmp + @char

END

SELECT @i = @i + 1

END

INSERT INTO @tmpTbl SELECT @Tmp

--select * from @tmpTbl