>>Quick question, I have got to move a VFP 7 app to VFP 9.02.
>>
>>Any thing I should be aware of in this process? I assume when I open the VFP 7 project in VFP 9 that it will do some kind of conversion.
>>
>>Thanks in advance for any thoughts.
>As Naomi said, make sure you check the "SET ENGINEBEHAVIOR " in the help or put in a line of code setting the engine behavior to 70 to get your SQL to work the same as it does in VFP 7.0.

That's not really a good advice. The best solution is to ONLY change this setting to 70 until you have fixed all the wrong select statements. If you don't fix the select statements, you may end up with wrong data. The default is 90, and it should always be that.