3 Replies Latest reply on Sep 6, 2013 10:32 PM by user13034857

    How to Remove Alpha characters using sql


      Hello all,


      I have to remove alpha characters in my data

      for example


      305N -->305


      I want to remove using regexp_replace function


      select regexp_REPLACE('305N','[:alpha:]','') NUM from Dual;



      Please suggest me.


      Thanks in advance.