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

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

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

security purposes on a production database

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