translate question

From: Shawn <spedwards_at_qwest.net>
Date: Fri, 12 Dec 2003 20:15:32 -0700
Message-ID: <wvvCb.146$X03.119868@news.uswest.net>

Ok, I made a mistake with a translate statement. It was my first time using translate of course. What I did was run this statement twice:

update DOC_AC_TEL set SSN = TRANSLATE
('915482376','123456789',TRANSLATE(SSN, '1234567890','9732581406'));
I should have only done it once. To "untranslate" the 2nd update I did. Would I be correct in running this:

update DOC_AC_TEL set SSN = TRANSLATE
('123456789','915482376',TRANSLATE(SSN, '9732581406','1234567890'));
Thanks,
Shawn Received on Fri Dec 12 2003 - 21:15:32 CST