Find phone number in text

[niall29]

I think this one will take a bit of thinking but this is what I am trying to do.

I have a database which I got alot of help from here with when I was creating it over a 2years ago attached to a VB6 App.
This was an App to keep track of employees (their attendance, position,deviations, remarks, etc)
I have discovered that managers have been putting phone numbers in that they caught employees calling. I have been told that because alot of supervisors(roughly about 100) have access to this info I should remove the area code from the phone numbers.
My question is how can I check a column which is a varchar (1000)field for 10 digits together and then remove or XXX out 3 digits.

Any help will be highly appreciated.
Thanks in advance

 

[jbenson001]

Maybe this will help?

http://www.codeproject.com/managedcpp/xpregex.asp

 

[niall29]

Thanks Jbenson001
I was actually able to get it using a PATindex which allowed me to use wildcards wo I was ale to tell it to look for 10 digits between 0 and 9
and it orked perfectly but thanks for your reply