Create a stored procedure like ROWS2COMMASTRING that receive the ownerid as
parameter.
It will be just a for select concatenating each row in the result field.
Then from your client you call select RESULT from ROWS2COMMASTRING.

Valdir.

----- Original Message -----
From: "Jacob Alberty" <calberty@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, January 13, 2004 5:21 PM
Subject: [firebird-support] Database Field Concatenate


> 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.
>
>
>
>
>
> Yahoo! Groups Links
>
> To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
> Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/
>