sql remove non numeric characters code example

Example: sql remove non numeric characters

SELECT REGEXP_REPLACE( fieldname, '[^[:digit:]]', '' ) AS newfieldname FROM tablename