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?