|
A in ASCII has numeric value 65; B is 66, etc 1 in ASCII has numeric value 49; 2 is 50, etc so A1 = 65*256+49 is smaller than AA = 65*256+65, hence sorts before AA. In EBCDIC digits have character values higher that letters, hence... ----- Original Message ----- From: Angela Wawrzaszek <awawrzaszek@nucorauburn.com> To: Midrange Mail List (E-mail) <midrange-L@midrange.com> Sent: Friday, October 26, 2001 12:26 PM Subject: sorting > I have a 2 position text field that I am sorting by. The codes go from AA, > AB...A1, A2... BB, B1 etc. We are sending this to a sql server. When they > sort it, the order is A1, AA, ...B1, BB The numerics are taking > precedence. They say it is sorting ascii. I thought ascii sort was > alpha/numeric also??? > _______________________________________________ > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@midrange.com > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l > or email: MIDRANGE-L-request@midrange.com > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.