You don't need GROUP BY in this case because you don't have aggregate functions in the column list

SELECT DISTINCT Client.AI,RTRIM(Client.Name)+' ('+RTRIM(Client.Code)+')' AS Client
 FROM Client

>In SQL Server, I have this:
>
>

>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?