how to split the multiple paramerters using sql query

See more:

C#

SQL-Server

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,