Re: sorting

M
Hello Angela,

You wrote:
>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???

It IS sorting alpha/numeric.  If you looked at an ASCII/EBCDIC chart you
would see that EBCDIC puts the numbers after the alphabetic characters while
ASCII puts the numbers before them.

On the AS/400 you could use sort tables to change the order of the sort.  I
doubt that SQL Server has any mechanism for doing that but you could check
with the administrators of that toy and see what they say.

Regards,
Simon Coulter.

«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»
«» FlyByNight Software         AS/400 Technical Specialists       «»
«» Eclipse the competition - run your business on an IBM AS/400.  «»
«»                                                                «»
«» Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\   «»
«» Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /   «»
«»                                                           X    «»
«»               ASCII Ribbon campaign against HTML E-Mail  / \   «»
«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»«»