DECLARE@strVARCHAR(100)
SET @str=',Rajesh,Ganpat,Varu,Smith,GANUSHARMA,Vandana,Anil,Rajvir,Feroz,Anup,Manoj,'DECLARE@lenINT, @lastINDEXINT,@currentINDEXINTSELECT @len=LEN(@str), @lastINDEX=0,@currentINDEX=0
WHILE @lastINDEX<=@len
BEGINSET @currentINDEX=CHARINDEX(',',@str,@lastINDEX)
IF @currentINDEX>0
BEGINPRINT SUBSTRING(@str,@lastINDEX,@currentINDEX-@lastINDEX)
SET @lastINDEX=@currentINDEX+1
ENDELSEBEGINPRINT SUBSTRING(@str,@lastINDEX,@len-(@lastINDEX-1))
SET @lastINDEX=@len+1
ENDEND