Looking for a find & replace (partial field) query

I am hoping to add some consistency to the phone number field of my existing customer base.

Some look like this: (XXX)###-#### while others look like this: XXX-###-####

I am hoping to use a query to make them all the same.

Tom