4 Replies Latest reply: Sep 20, 2013 6:49 AM by Srini VEERAVALLI RSS

    Sort Employee Number

    957471

      Hi Experts,

         

              I'm using OBIEE 11.1.1.5(11g) and Datasource has Oracle SQL Developer.I have a scenario where I need to sort the employee Number in report and column is Varchar2.Since,this column contain alphanumeric.I couldnot cast the column into integer.I need to sort the data in ascending order.

       

      Example:           Result need to be:

      1                             1

      10                           2

      100                         10

      2                            100

      .                                .

      .                                .

      abc12                     abc1

      abc1                      abc12


      Hope i'm clear.Plz suggest me a solution.

      Thanks in advance