Formatting phone numbers

[angelards]

I have a phone Field where records vary with how they were entered with punctuations: examples:

2485551212
248.555.1212
248-555-1212
248 555 1212

along with a few others. I am looking for a script to write them all to the same format. preferable 248-555-1212 or no punctuation at all.

I'm not sure if I should do a replace script to remove the unwanted characters or if there is something that will delete all non numeric characters from the field and then do an input mask?

[ck9663]

Try:

select replace(replace(replace(phone_number, '-',''),'.',''),' ','') from yourtable

-- CK