Using QMF

AO., AO(n). -- Sort rows in ascending order

To put rows in a report in ascending order by the values in some column, put AO. in that column. (Make sure that you use the letter O.)

The sorting sequence for character data, in ascending order, is as follows:

1. Special characters, including blank
2. Lowercase letters, in alphabetic order
3. Uppercase letters, in alphabetic order
4. Numbers, in ascending order
5. NULL

The sorting sequence for DATE, TIME, and TIMESTAMP values is chronological.

The internal value of the data determines the sorting sequence for double-byte character set (DBCS) data. It is generally not meaningful.

The following query produces a report listing the name, job, and years of employment for each employee in department 84 in ascending alphabetic order by job.

When you run this query:

Q.STAFF | ID | NAME | DEPT | JOB         | YEARS | SALARY | COMM |
--------+----+------+------+-------------+-------+--------+------|
        |    | P.   | 84   | P. AO.      | P.    |        |      |

QMF produces this report:

NAME       JOB    YEARS
---------  -----  -----
GAFNEY     CLERK      5
QUILL      MGR       10
DAVIS      SALES      5
EDWARDS    SALES      7