>>>>>>I have a VFP 8 application that runs the following query in 0.01 seconds. When I run it in VFP 9 SP1, it takes about 7 seconds:
>>>>>>
>>>>>>SELECT * ;
>>Yes, I had this problem when VFP 9 first came out. Because of the bug to STR(), I postponed the upgrading of the program to VFP 9 until VFP 9 SP 1 came out. VFP 9 SP 1 fixed the STR() but not TRANSFORM() as you mentioned.
>>
>>I was hoping that there was a workaround so that I would not have to create a new index. Using SET ANSI is not a good solution for me, but at least STR() is fixed. I think IIF(lFtdAdversary, "Y", "N") will be a good substitute for TRANSFORM in my index.
>>
>>Thanks again for your help!
>
>I think you found a bug and need to post it on MS site.

FYI: I submitted a bug report to Microsoft.