Hi Vlad,
This bug have been discassed a few times already. The earliest one
Re: Select speed question Thread #
971916 Message #
972114>thanks for this question in UT.
>AND SERGEY BIG thanks for this answer. We must know the bugs in VFP? and how we can them go round.
>
>
>>When SET ANSI is OFF, VFP9 doesn't use indexes with STR() function for Rushmore optimization because of a bug. A workaround is either SET ANSI ON or replace STR() WITH PADL(,10).
--sb--