Combine values

[chrisbo]

Hi,
Using SQL server, I need to update a field in table A with a combination of one or more values from the same column in table B.
Example:

A
Col1
field1

B
Col1
John
George
Paul
Ringo

The result in field1 could look like this: "George, Ringo".
(I will use a select statement to extract which rows from table B I want.)

This would have been easy if the values to be combined had been in a single row, but I don't know how to deal with fetching from a single column. How can I do this?

I'm not new to programming, just to SQL...

/Chrisbo

[Vidhura]

Hope this helps

declare @abbr varchar(1000)

select @abbr=COALESCE(@abbr+ ',', '')+Col1 from B

select @abbr