>One comment and a solution.
>The comment:
>Naming an alias GROUP and using it in a query can only cause trouble.
>The solution:
>create a one record table of any structure, then
>SELECT Description AS Descript,Numero FROM GROUP WHERE IRegion>0_ ;
>UNION SELECT 'Public',0 FROM OneRecordTable ORDER BY 2
>Notes:
>1. You don't need to use the AS ... syntax in the UNIONed parts of the query.
>2. The length of GROUP.Description must at least be 6 or 'Public' will be truncated in the extra record.
Thanks, it works.