>Cetin;
>
>What do you mean "the SQL version wan't using an index"? If you mean it wasn't rushmore optimized, then I have tried also the rushmore optimizable form and it didn't work. I have also posted at the other forum (MS forum) a question about how come the simplest SQL query is not rushmore optimized. See
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=384360&SiteID=1>
>Thanks as always. I have just returned from Israel... Miss the weather already!
>
>Alen.
Hi,
When I saw that thread your seek was using the full index key while SQL was not using a signature of the key. Something like this as I remember:
index: left(...)+...+...
SQL was using left(...) = ...
I already saw new one before this one and replied there. cpcurrent() # cpdbf() sounds to be the problem.
Cetin