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

    How to Remove Alpha characters using sql

    user13034857

      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.