>Is there any third party tools which can analyse the oracle sql and convert it to fox sql syntax?
>
>for ex:
>in Fox between(x,1,6)
>
>in case of oracle
>
>x between 1 and 6.
>
>How to solve this problem.

Not that I am aware of. I have used quite a bit of standard SQL code in my VFP apps with no problems. Now I can not say I have tested every possibility. But anytime I revert to using pure SQL code, VFP correctly returns the selected data, updates correctly or deletes the desired data. I would say to just try your existing code and fix only what is broken.