I have 8,000 records in a table. I would like to remove any characters such as(,),- that are currently there separating the area code from the number, being left with just the numbers.
Example:
Current: (800)555-5555
I would like to see: 8885555555
Then I can set the format and input mask properties for future entries.

Thanks