>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
replace phone with chrtran(phone,"(,)-","") all
If it's not broken, fix it until it is.
My Blog