Bug with Find Operators "less than"
When using the "less than" (<) operator in Find, I get some odd results.
e.g. omit <1000 still includes 500 and 250 etc.
but omit <500 removes 1000, 10000 etc.
I think that the number ordering is weird, and it calculates 1 is less than 5, regardless of how many zeroes come afterwards. Has anyone encountered similar problems, or a fix?
I'm using FileMaker Pro 11 Advanced 11.0v1 on a Mac.
Many thanks, Philip