5 Replies Latest reply on Jan 12, 2017 1:33 AM by Vite DBA

    Case-insensitive column sorting using column headers to sort in a Classic or IR Report.

    bondurs

      Greetings:

       

      I am currently using APEX 4.2.6.00.03, Oracle database 12.1.0.2.0

       

      Is there a way to set an APEX IR or Classic report to sort data in a case insensitive-manner by using the column headings to sort ascending or descending?  I know I can transform the data upon it being entered into the database into INITCAP, or transform the data to INITCAP when being displayed in a report, but our customer does not want this.  They want it displayed as entered but do not want any data starting with "a" to appear after any data starting with "Z" in ascending sort order.

       

      Thanks

      Stan