I have a result set from the following
select petname where ownerid = 100674, the results will look like this

JETHRO
FLUFFY
FOOFOO

is there a method in firebird to turn these results into a concatonated
list such as
JETHRO, FLUFFY, FOOFOO
My reporting software does not support this clientside so i have been
looking for a solution server side (preferably through stored procedure)
but i have been unable to find any way to accomplish this through a
stored procedure.