>Thank you. Of course, I have read your message. It describes the part of my problem. CPCURRENT() don't match CPDBF() and VFP9 won't use indexes on character expressions for optimization. But in VFP8 it works normally as I expect.
>I would like to know, if it is a bug or the new intended feature.
>In the first case I will wait for service pack 1. In the second case I must rewrite my programs, because the select without optimization is very slow.
It's not a bug but fix of a bug. In previous versions you may get different results when index is used and w/o index because table data is translated into CPCURRENT() but indexes don't. IOW, when CPCURRENT() don't match CPDBF(), indexes don't match data.
--sb--