Working on a database.
A field has 5 spaces for check numbers. The field is a character field.
There are check numbers from 1000 to 10250. A search for check numbers > 10240 yields a starting check of 2883 AND all subsequent checks to 9999 at which point it jumps to 10241.
A simple program that says:
A = "10250"
B = "250"
IF A > B
? "A > B"
ENDIF
IF B > A
? "B > A"
ENDIF
This results in a statement of B > A.
What am I missing?
| 
A < B, Any programers can explain?
