I'm a new user. Imported large data set. Need help formatting with SQL!

I have imported a large data set into one table called USERS. One field is a phone number field called Contact_Number. Some numbers are listed with dashes and periods separating the area code and prefix. e.g. 555.555.5555 , and 555-555-5555.

There are several thousand entries. How can I write a query that will remove the dashes and periods and just leave the phone numbers as one number without dashes. Any help would be appreciated.

Hi mjk

USe REPLACE function Oracle SQL

select REPLACE('555-555-5555' ,'-') from dual
/

HTH