Is it possible that some of the values shown as zero are in fact NULL values? Try with count all for isnull( field1 ) to intx and see what you get.


Saludos,
Hector

>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