Hello, I�m trying to filter a column of phone numbers that contains spaces, parenthesis, dashes, and possibly letters using sql with the following query. Am I going down the right path with the following sql statement or should I be doing something totally different? I�m trying to say use the contact_phone field and replace all non-digit characters with �� (nothing). Thanks for the help in advance.
select replace(contact_phone,! REGEXP "[[:digit:]]",'') as filtered_phone; Free Grafton
