Split Delimited Value Into Tabular Form

DECLARE @Temp TABLE (Data VARCHAR(512))
DECLARE @ComChar    VARCHAR(512)='Delhi,Mumbai,Chennai,Calcutta',
@Seperator  VARCHAR(5)=','
WHILE CHARINDEX(@Seperator,@ComChar,1)<>0
BEGIN
INSERT INTO @Temp(Data)
SELECT SUBSTRING(@ComChar,1,CHARINDEX(@Seperator,@ComChar,1)-1)
SET @ComChar=SUBSTRING(@ComChar,CHARINDEX(@Seperator,@ComChar,1)+1,LEN(@ComChar))
END
INSERT INTO @Temp(Data)
SELECT @ComChar
SELECT * FROM @Temp