SELECT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Client FROM Client GROUP BY Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')'However, this is not compliant with VFP. Is there a way to make that group expression in a way that it would fit both backends?