How to seprate the values in sql

Question

hello ,

i m table some values with comma like this

id  core
1  IT,Design Art,SCO
2  IT with Mobile,Art with Design pen,ETC


i wants to list of comma seprate
plz help me and give me idea

i wants like this
1----------IT
1---------Design Art
1--------SCO
2------------IT with Mobile
2-------------Art with Design pen
2------------ETC


so plz help me