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.