Hi all how to split the large text by using ',' in sql server
my query like this,
select SUBSTRING('city,sate,county,vvv',0,CHARINDEX(',','city,sate',0))
select SUBSTRING('city,sate,county,vvv',
(CHARINDEX(',','city,sate,county,vvv',0)+1),(lEN('city,sate,county,vvv')-(CHARINDEX(',','city,sate,county,vvv',0))))
select SUBSTRING('city,sate,county,vvv',
(CHARINDEX(',','city,sate,county,vvv',0)+CHARINDEX(',','city,sate,county,vvv',0)),(lEN('city,sate,county,vvv')-(CHARINDEX(',','city,sate,county,vvv',0))))
am given to 2 parameters i.e city, state working fine. but 2 or more parameters are am given not working exactly.
i want output this format .
city='city',
state='state',
county='county',
vvv='vvv'
i.e separated or split by comma this words. how to write the query.
please help me,