7 Replies Latest reply on Jul 23, 2015 4:59 AM by Kam_oracle_apex

    Want to pick a numeric value in SQL

    Kam_oracle_apex

      Dear Friends

       

      I have a character field in a table. Values in a field like below

       

      col_value

      50/60

      103/104

      49/50

       

      I want to pick the values before / eg 50,103,49 how can i do it in SQL.

       

      Regards

      Kam