Robert,
See
Re: How To: Group Data and club a field of the group using S Thread #
763525 for similar select with UDF().
>I have an interesting problem (I think).
>
>I have table1
>mykey myvalue
>a x
>a y
>a z
>b c
>b d
>b e
>b f
>b g
>
>I want to end up with table2
>mykey myvalues
>a xyz
>b cdefg
>
>I can do this concatenation using a scan, but I want to do it only using SQL. The number of values for a key is random.
--sb--