A
axelcore
I have a table that has phone numbers stored in 1 of 2 formats.
(555)555-5555
(555) 555-5555
I have checked and the data is actually stored like this. I would like to
do an update query that puts the phone numbers in the format 5555555555 but i
haven't been able to achieve this.
Thanks in advance for the help.
(555)555-5555
(555) 555-5555
I have checked and the data is actually stored like this. I would like to
do an update query that puts the phone numbers in the format 5555555555 but i
haven't been able to achieve this.
Thanks in advance for the help.