field=field+', ' in SQL

[stefan b]

Hi! :-OHow can I select from

InvId Company

1 a
23 b
56 c
12 a
21 c

this data set:

Company Invoices

a 1,12
b 23
c 56,21

Many thanks in advance! _____________ stefan bornuz

[Jeremy Oldham]

stefan, Take a look at the following article. http://www.sqlteam.com/item.asp?ItemID=256[^] Jeremy Oldham

[stefan b]

Thanks Jeremy! I just hoped that MS SQL has a trick for doing this with a 'simple' query, without the need of procedural processing.:) Thanks again, _____________ stefan bornuz