6 Replies Latest reply: Jun 14, 2013 5:01 AM by user10214361 RSS

    Interactive Report - sort strings/numbers in the same column

    Locke90210
      Hi all,

      I have an interactive report and have a column value.

      It has type varchar2 in Database.

       

      Problem: There are existing numbers and chars in this column.

      Now I want to sort as numbers as chars.

       

      Now it's like this:

      10

      2

      23

      3

      no

      yes

       

      I want like this:

      2

      3

      10

      23

      no

      yes

       

       

      How can I receive this???

      All suggestions are welcome.