Find Jobs
Hire Freelancers

SQL Query to Remove Characters in Phone Number

$10-30 USD

Closed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 17229621

About the project

77 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
77 freelancers are bidding on average $23 USD for this job
User Avatar
Hello There, How are you? I hope you are having great time in your life. I am having more than five years of experience in wordpress. I can make SQL query for you. That will remove all unwanted character from your phone number. Please let me know more about your requirement. Looking forward to work with you. Waiting for your quick and positive reply. Thanks RWS
$20 USD in 1 day
4.9 (277 reviews)
7.9
7.9
User Avatar
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
$28 USD in 1 day
5.0 (314 reviews)
7.8
7.8
User Avatar
Hi there. I do SQL and I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details.
$30 USD in 1 day
5.0 (512 reviews)
7.0
7.0
User Avatar
I will do it immediately and i have 5+ experience in web development. I am sure will give you amazing results. if you have any questions please feel free to chat before ordering. My skills: - Magento 1 & 2 Theming and Customization - MySql - jQuery - HTML5 And CSS - Cakephp and Wordpress - AWS server setup specialist - Server administrator - Linux Thanks
$25 USD in 1 day
4.9 (122 reviews)
6.6
6.6
User Avatar
Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention SQL because this is my favorite field and database projects are among tasks I work with regularly and know exactly how to handle them. I'm a very experienced and skilled MS Access developer as you can easily check for yourself. You're welcome to visit my portfolio and get an idea of who I am and what services I deliver to my clients. You mention that you need somebody to create a query that will remove certain characters from 2 tables. This can be done by using SQL and I could do it for you in a couple of hours from awarding. I never ask for any payment in front. I claim milestone release once the project is completed and my client is happy with the result. I'm looking forward to hearing from you. Paris Pallas
$30 USD in 0 day
4.9 (84 reviews)
6.7
6.7
User Avatar
Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. what we could do is to parse each character in each row of the phone number field and if it is not in 0 to 9 then replace it with empty space. Would you like to keep the data as such and write a function to always return the data without characters? Or you like to replace the data? Either way is fine, I can do this at the mentioned budget. Thanks Roni
$30 USD in 1 day
5.0 (96 reviews)
6.7
6.7
User Avatar
Hi i read your project description and would like to help you with it. i have more then 5 years of Webdesigning and Development experience with PHP and wordpress knowledge. i can finish your job in your timeframe professionally. Please message me in PM for more details. Have a look at my reviews to understand the work quality i deliver. Thanks
$25 USD in 1 day
4.9 (142 reviews)
6.4
6.4
User Avatar
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
$25 USD in 2 days
5.0 (247 reviews)
6.4
6.4
User Avatar
Hi Sir, Good morning in America! Hey, So I am senior software developer with the C# Programming language and the Sql Server database. I am also strong with MySQL Server and Oracle database. I am able to help and start right now, as I am availalble out of wrapping up other project. Can you please ping me to discuss further? Kind regards, Sergio
$30 USD in 0 day
4.7 (90 reviews)
6.8
6.8
User Avatar
Hi, How are you? I am a database developer with over 5 years of development experience. I’ve carefully gone through your job post. I am very much interested in your project with all of your requirements. I feel very confident on your project and You will get the "Best Result" if you work with me. I work hard and you will surely get the result in a promised time. If you give me all information about your job, I can start working immediately. If you want, I will show you my previous work... Looking forward to discussing with you the details. Best regards.
$25 USD in 1 day
4.9 (40 reviews)
5.8
5.8
User Avatar
Project Description 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.
$15 USD in 1 day
4.9 (94 reviews)
5.6
5.6
User Avatar
Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with more than 10 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, and related tasks and projects. I can write the SQL code for your requirement in two hours of work or less. Let me know via chat if you are interested. Thanks.
$25 USD in 1 day
4.9 (23 reviews)
5.7
5.7
User Avatar
I have similiar queries done, please contact me if you need the script quick and cheap, i will be available for you :)
$10 USD in 0 day
5.0 (44 reviews)
5.5
5.5
User Avatar
Dear Sir, I'm expert at Sql check as i'm MCITP, please message me to start this project. Kind Regards, NourElDeen
$19 USD in 0 day
5.0 (44 reviews)
5.5
5.5
User Avatar
Hi there. I am very much interested in updating your phone numbers table to remove all characters on the entries except the numbers. I am an experienced website developer focused on creating modern websites using PHP, MySQL, HTML5, CSS and JavaScript. I also use popular frameworks like Bootstrap, WordPress, Foundation, AngularJS and Codeigniter. Get to know me more by visiting my profile here https://www.freelancer.com/u/earvinpiamonte. Hope to hear from you soon. Thanks.
$10 USD in 0 day
4.9 (108 reviews)
5.4
5.4
User Avatar
I am having more than 9 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utilizing my knowledge and skills.
$30 USD in 1 day
5.0 (38 reviews)
5.3
5.3
User Avatar
Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards
$25 USD in 10 days
4.7 (25 reviews)
5.0
5.0
User Avatar
Hello, I am an expert in SQL, and can do this for you within 10 minutes max. Available to do right now. Regards
$30 USD in 1 day
5.0 (23 reviews)
4.7
4.7
User Avatar
Hi i have expertise in slq server and please let me know di we have also characters in the column or not so that i wil modify my query and let you know
$30 USD in 1 day
4.8 (20 reviews)
4.5
4.5
User Avatar
hi, would be glad to help you with this project. regards, yuri .
$25 USD in 1 day
4.9 (33 reviews)
4.5
4.5

About the client

Flag of UNITED STATES
Nashua, United States
5.0
3
Payment method verified
Member since Jun 24, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.