Logic behind the comparison filter for invoice numbers, AR and AP

For an integration and extension we are designing, we need to have a clear understanding of the logic used by the same system when the user uses the following filters for invoice numbers:

- Greater/Less/In Between

Given invoice numbers for Payables and Receivables Transactions are VARCHAR not NUMERIC., which logic is the system using to determine what's in Between or what's greater or smaller.

Thanks!