I need an sql query that will format all phone numbers in a table column and remove any characters(parentheses, dashes, and dots), and leave only numbers. I think there's 2 tables this needs to be done in.
83 freelancers are bidding on average $23 for this job
Hello, As an expert in SQL, i am very much interested to write the required query. Is it for ms sql server or MySQL ? Looking forward to have a positive response from you. Thanks
Hello It looks like puzzle at first look, but I have just googled SQL code for String replace operation that uses regular expression. I am sure it's possible to adapt it for your task