sql remove non numeric characters
snippet in sql

sql remove non numeric characters

user9586

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