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
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