Member Avatar for riyapethe

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

  • 2 Contributors
  • 1 Reply
  • 45 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

Fetch column value and store it into the string. Use Split method of string to convert comma separated string into one dimensional string array.

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.