>>>>I'm preparing to do anapp coversion where I will convert from DBF to SQL Server and begin using SqlExec(). I have lots of SQL strings in my app already that run fine against local DBF tables, so I'm wanting to see if there is a list somewehere or if you can give me advice on what syntax and stuff that works fine on DBF, but that will need to be modified to run on SQL server. This way I can scan my SQL strings and look for areas that I need to change.
>>>
>>>You may find this link helpful
>>>
>>>http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
>>
>>heh...that's pretty slick.
>>Ya know i seems it shouldn't be to difficult to write a VFP Syntax to TSQL Syntax converter program.
>
>Would be too difficult for me to automate it - but I can easily (in 99% cases) convert the code manually.

awwww...nothing is impossible though! Bet if there *was* such a tool every VFP developer would want it. Fewer and fewer VFP apps and most of the VFP data going to SQL.....