Find returns incorrect results

[Reid]

When I search a non-indexed number field for the number 2, it returns both the number 2 and 3. Any ideas?

 

I am using FM12 with FMServer 12 on a windows 7 PC.

[No_access]

I know you said it is a number field, First please confirm the field is actually a  number field or TEXT field storing numbers ?

how are you searching, with a script ? please show the script if this is the case.

[Reid]

The field is a number field. Searching with the find view, just a basic search. No scripts. 

 

Oddly enough, it turned out to be Java. Once we reverted Java back to update 21 instead of 25 on our server computer, everything was fine. 

 

Thanks for your time! Java beware!!

[LaRetta]

Wow!  I had not seen this!  Thank you for posting, Reid!  It seems Java has always been one problem after another.