--- In firebird-support@yahoogroups.com, Svein Erling Tysvaer <svein.erling.tysvaer@...> wrote:
>
> > but even something simple like:
> > SELECT LIST(maccounts.ccode, ',')
> > FROM maccounts
> >
> > will return duplicates as comma separated, so a 100 records with 25 values repeated will still return a string with 100 values comma separated.
>
> This bit is simple, just do
>
> SELECT LIST(DISTINCT maccounts.ccode, ',')
> FROM maccounts
>
> HTH,
> Set
>