SQL Server 2008 - Loop through/split a delimited string

DECLARE @str VARCHAR(100)
SET @str=',Rajesh,Ganpat,Varu,Smith,GANUSHARMA,Vandana,Anil,Rajvir,Feroz,Anup,Manoj,'
DECLARE @len INT, @lastINDEX INT,@currentINDEX INT
SELECT @len=LEN(@str), @lastINDEX=0,@currentINDEX=0

WHILE @lastINDEX<=@len
BEGIN
SET @currentINDEX=CHARINDEX(',',@str,@lastINDEX)
    IF  @currentINDEX>0
    BEGIN
        PRINT SUBSTRING(@str,@lastINDEX,@currentINDEX-@lastINDEX)
        SET @lastINDEX=@currentINDEX+1
    END
    ELSE
    BEGIN
        PRINT SUBSTRING(@str,@lastINDEX,@len-(@lastINDEX-1))
        SET @lastINDEX=@len+1
    END

END

DECLARE @Str NVARCHAR(MAX)
SET @Str = 'Rajesh,Ganpat,Varu,Smith,GANUSHARMA,Vandana,Anil,Rajvir,Feroz,Anup,Manoj'
DECLARE @IND    INT

SET @IND = CHARINDEX(',',@Str)

WHILE(@IND > 0)
BEGIN
    SELECT SUBSTRING(@Str, 1,  @IND-1)

    SET @Str = SUBSTRING(@Str, @IND+1,  LEN(@Str))

    SET @IND = CHARINDEX(',',@Str)
END

SELECT @Str