Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Sorting alphabetically in iformix

    Is there any function which can sort a column alphabetically, in informix sql.
    I am displaying data pulled from (a column of a table in) an informix db, onto a JSP page, in an html table's column. This html table's column is supposed to sort data alphabetically, on cliking a button on the same page. Currently, the column gets sorted on the basis of ASCII values of first letters; i.e., A, B, C, D........X, Y, Z, a, b, c, d...x, y, z;; that is, capital letters first, and small ones later on.
    Can some function be used in SQL at the time of pulling data via SQL, so that the data comes out alphabetically sorted, instead of ASCII-cally?
    Please help.

    Thanks a lot in advance.
    Last edited by insix; 07-20-04 at 04:45.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •