Could it be that your index is corrupted? LOCATE uses Rushmore if the search expression is optimizable. This is the case in your first example, in the second case, VFP doens't use the index, therefore you might get different results. Try recreating the indexes.
HTH
>Now this is weird :(
>After further experimentation I found the following:
>If I open table A and ask for a LOCATE on the primary index integer field it works; If I open table B and ask for a LOCATE on the primary index integer field, it DOESN'T work; if in table B I write
>LOCATE FOR ALLTRIM(STR(INTEGERFIELD))= "NUMERICVALUE" it works!!!. I am more confused than ever.
>Anyone has an idea what's going on?
>Thanks in advance.
Daniel