mssql remove non web characters from string code example
Example: sql remove non numeric characters
SELECT REGEXP_REPLACE( fieldname, '[^[:digit:]]', '' ) AS newfieldname FROM tablename
SELECT REGEXP_REPLACE( fieldname, '[^[:digit:]]', '' ) AS newfieldname FROM tablename