Change Format of Phone Field

[Chaster]

This post is actually a continuation of my previous.

My tables BusinessFax field was orginally set up as text with the standard
phone number input mask.

I have now changed the field so there is no input masking done in the table
itself. I will apply the mask to my forms whdn necessary.

My question is:

Is there a way to go back and replace the existing data that is in my table
as (213)-222-2222 with 2132222222
I need to remove the inputmask stuff ( )- - and just leave the numbers.

I tried creating a new table where the BusinessFax field did not have the
inputmask and then doing an append.

I am getting errors on 626 records that violate validation rules. Probably
the data that is my in table that is not formated with the inputmask.

Any help is appreciated.