Posted 1/20/2020 12:12 (#7987859 - in reply to #7987830) Subject: RE: A < B, Any programers can explain?
Elmira, Ontario
Field is a character field. Looks at left character in each entry first. Doesn't pay attention to the second character unless there is a tie. 2 is a higher character than 1.
If you want the full number to be compared, you need to either change the field to a number field, or change the results to numbers to do the comparison.