Question: Why does the Customer Name and/or Supplier Name Pulldown Sort by upper case then lower case? For example, if you have 3 names “BC”, “AB” and “ac”, the system will sort as “AB”,”BC”, then “ac”.
Answer: This is a natural sort. Each letter, Upper case, and lower case, have an ASCII number assigned to them. For example, “A” is 65, and “a” is 97. Every key on the keyboard has an ascii number associated with any version of the key – lower case, upper case, CNTL, Alt and combinations of them. And these numbers are used to sort the fields. So you can see that is why upper case "A through Z" comes before lower case "a through z".
|