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
Split Delimited Value Into Tabular Form
This code snippet is for to Split delimited Value Into Tabular Form.