sql comma seperated value

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

Newbie Poster

2 posts since Apr 2011

Reputation Points: 10

Solved Threads: 0

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

Posting Genius (adatapost)

Moderator

8,648 posts since Oct 2008

Reputation Points: 2,136

Solved Threads: 1,241

This article has been dead for over three months

You