Viewing 5 posts - 1 through 5 (of 5 total)
I get what both of you are saying....and you are right...i will implement the options that you two have thrown my way.
thanks for all of your help...
April 17, 2008 at 1:01 pm
How about this? I tried this and it seemed to work:
UPDATE Employee
set
--Home Phone Number
EMP_HOME_PHONE=
reverse(substring(EMP_HOME_PHONE,1,3) ) + '-' +
reverse(substring(EMP_HOME_PHONE,5,3)) + '-' +
reverse(substring(EMP_HOME_PHONE,9,4))
It...
April 17, 2008 at 12:38 pm
Im sorry maybe i should have stated that the database that I will be scrambling these phone numbers as well as other pieces of "Personal Data" is a copy of...
April 17, 2008 at 12:08 pm
I dont receive an error. Its just when I go to that destination server to verify the copy...It is not there. Even after refreshing a few times. I have full...
April 10, 2008 at 12:45 pm
Viewing 5 posts - 1 through 5 (of 5 total)