remove non numeric values from string column sql query code example

Example: sql remove non numeric characters

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