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