Hi,

I want to concatenate multiple records of a column in a single field.like
I have data
num id
123 1
456 1
765 1

i want to make a new table from this as
number id
123,456,765 1

can anyone help me in this?

I m using ASP & SQL server

Please don't do this!

Make a query to produce a *RESULT* like that, yes. But please don't create a new table like that. You will lose the ability to make many kinds of good queries when you store data in a concatenated list like that.

Anyway:

This is a very general answer:
http://www.devcow.com/blogs/adnrg/ar...le-record.aspx

But if you only have a single ID value then you can do it more simply:
http://www.sqlteam.com/article/using...limited-string