Text fields sort in the order of Numeric first, then Alpha.

1. All Numeric IDs list in numeric order.
2. Alpha and Alpha-numeric IDs list in numeric then alpha based on the first character only.
3. The second character within the first character order is the second sort with alpha then numeric.
4. It continues through all the characters in the ID. Blank characters come before a zero.

For example, the Invoice ID and Customer ID are text fields. You can enter numbers for the ID, but it treats it as text.

The following is an example for the sort order of fields on a report.

1
2
3
10
200
001C
0A1
10A
1A
B

Enter alpha-numeric invoice numbers for customer invoices