Hello EveryBody.

i need to group (by upcharges for frames) my frame options. so i end up with 1 record for each different price up-charge. the following works great for this.

sele ;
      a.* ;
   from partoptions a ;
   group by a.option, a.upchoice, a.priceadj

however, i also need in each row to contain all of the different option-codes for that 'group' combined in one field. something simular to the sum(), but, i don't need it added up (it's a character field anyway), i need it combined in a string (like "Opt1, opt4, opt6, opt11, ...").

any ideas other then to scan through the table and collect?

thanks for all your help as always!