sele ; a.* ; from partoptions a ; group by a.option, a.upchoice, a.priceadjhowever, 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, ...").