>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?
BTW, this query doesn't make much sense. There should be other fields here or you can use DISTINCT instead.
If it's not broken, fix it until it is.
My Blog