Thanks Naomi, I remembered a couple of these and the link will help also.
>>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.
>
>Some behavior was changed in the SQL Engine. Say, if you don't have a record for the condition, the select aggregate will now return NULL as opposed to originally returned 0.
>
>Check also
Moving applications to VFP9