Errr No _ I finished school a long time ago - funny.
nick_wakefield_at_hotmail.com (Niko) 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 Tue Nov 19 2002 - 00:58:49 CST
