Use Sybase ASA. It has an aggregate string function called List().
"Niko" <nick_wakefield_at_hotmail.com> wrote in message
news:9da94cd1.0211140835.56fa096b_at_posting.google.com...
> Hi,
>
> Does anyone know a way to do the following, given a table like
>
> Field_A, Field_B
> a first word
> a second word
> a third word
>
>
> then runa group by query on it to merge the contents of field_b
> seperating with commas.
>
> select field_a, merge(field_b,',')
> from table
> group by a
>
> resulting in
> Field_A New_String
> a first word, second word, thrid word
Received on Thu Nov 14 2002 - 14:43:51 CST
