DB2 graphic  QMF Version 8

Sorting sequence

The sequence for sorting character data in numeric order is:

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

The sequence for sorting numbers is ascending order. The sequence for sorting DATE, TIME, and TIMESTAMP values is chronological. The sequence for sorting DBCS data is determined by the internal value of the data and generally is not meaningful.

Examples:


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004