remove non numeric from string sql server code example

Example: sql remove non numeric characters

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