4 Replies Latest reply on Sep 20, 2013 11:49 AM by SriniVEERAVALLI

    Sort Employee Number


      Hi Experts,


              I'm using OBIEE 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