3 Replies Latest reply: Sep 6, 2013 5:32 PM by user13034857 RSS

    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.