ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
Customer Name and/or Supplier Name Pulldown Sort Order.
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". 





   

Article ID: 956