If you are using VFP 5 than MSKB#
Q164869 maybe relevant to your problem.
Otherwise turn off Rushmore SET OPTIMIZE OFF and run again. If you get correct result delete all indexes an recreate them from scratch.
>Hi all.
>I have a table with an integer field. I have several zero values and several non-zero values. If I issue this command:
>count all for field1<>0 to intx
>I get intx=5 or whatever, but this:
>count all for field1=0 to intx
>gets me 0 records.
>By the same token:
>replace all filed1 with 4 for field1<>0 replaces all non-zero records, but;
>replace all field1 with 4 for field1=0, replaces nothing.
>What am I missing?
>TIA
>Ulises
--sb--