Binary field with values not searchable

[michaelnyc]

I have an unstored calculation field that is a 1 or a 0. There are multiple records that have the value 1 and multiple records that have the value 0.

When I perform a find in this field, no search results are returned for 1 or 0.

I can sort by this field properly.

Is this a corruption problem? If so, what is the best remedy? Thanks, in advance, for your response.

[bcooney]

I wouldn't jump to the conclusion that your file is corrupted. Create a new layout in table view that includes this field. This might simplify any context issues.

Now try your find. Enter 1 in the unstored calc field (it is a number result calc, right?).