>SELECT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Clientxxx > FROM Client >GROUP BY Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' >