>>>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.

I agree that setting the engine behavior to 70 may not be the best solution but the SQL would provide exactly the same results it does now. I would also assume that if the app was written in 7.0 that someone would realize by now that they were getting the wrong data from the SQL.