my table structre like this
ID nAME
1 Mumbai,Pune,Chennai

i want output of name like this
Name
Mumbai

Pune

Chennai

pl help
m 'new to sql

Thanks in Advance

post your code here, i will fix it.

split your Name values with "," and then use as per your needs

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.