>Hi,
>
>I have the following SQL Select code when using VFP database and it works:
>
>
>select Mytable.myfld1 + Mytable.myfld2 as MyGroup from MyTable group by MyGroup
>
>
>When executing this SQL Select against SQL Server it fails. How do I change this SQL Select so that it would work for both VFP and SQL Server?
>
>Thank you in advance.
No way:( You can't create SQL that would work unchanged for VFP and SQL all the time. You are wasting your time trying to make it compatible IMHO. Write them depending on backend.
Cetin