Thank you for the answer,

It work fine unfortunately it is slower !

>This is a known bug, DISTINCT on sub-select in select list.
>
>As workaround you could use a LEFT JOIN instead :
>
>SELECT
> DISTINCT
> Q2.*,
> cfl.FIRSTLASTNAME AS R_FIRSTLASTNAME
>FROM
> CUSTOMER Q2
> LEFT JOIN CONCAT_FIRSTLASTNAME(Q2.FIRSTNAME ,Q2.LASTNAME) cfl ON (1 = 1)
>
>
>Regards,
>Arno Brinkman
>ABVisie
>
>

Best regard,

--

Fabrice Vendé
fabrice@...
-
SARL I N F O C O B
Développement, formation, matériel, logiciel
http://www.infocob.com