elham_azizi_62 (10/7/2012)

---

I want to have this:

select column1 from table1

column1

a

b

c

and result:a,b,c

and i donot want to use cursor or virtual table.please help me.thanks

GilaMonster (10/7/2012)

---

Take a look at the last option here: http://databases.aspfaq.com/general/how-do-i-concatenate-strings-from-a-column-into-a-single-row.html