SQL Query to Remove Characters in Phone Number - 24/06/2018 16:06 EDT

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.

Skills: Database Administration, Microsoft SQL Server, MySQL, PHP, SQL

See more: sql statements will change phone number publisher, digit letter phone number sql, database query phone number, zencart remove phone number sign, iphone address book sql statement phone number, oracle sql format phone number, oracle sql phone number format, extract phone number file save database, clone phone number, outlook 2007 contacts sign phone number

About the Employer:
( 0 reviews ) United States

Project ID: #17229623

Awarded to:

$20 USD in 1 day
(3 Reviews)

9 freelancers are bidding on average $24 for this job

$20 USD in 0 days
(125 Reviews)

I have already done this for apostrophe removal in a column. Please share with me the table details with sample data so that i could provide you with the query.

$30 USD in 1 day
(159 Reviews)
$35 USD in 0 days
(126 Reviews)

Hi greetings for the day! I am a senior php and WordPress developer and i have 7 years of experience in web development. I am a individual developer and i am not a company and doing freelancing individually. I wil More

$35 USD in 1 day
(66 Reviews)
$10 USD in 1 day
(42 Reviews)

i can do that... it is no big deal... looking forward to get some response... thank you for reading this...

$25 USD in 1 day
(7 Reviews)

Hi, This is simple task for me. I can do this. thanks Mahesh

$17 USD in 1 day
(3 Reviews)
$20 USD in 1 day
(0 Reviews)