That would work except for the fact that it needs to be dynamic.  It is quite possible the names and number of columns to be converted would be different from...

I look for a company in which the managers take their employees seriously.  Too many managers think only their opinions count (they are the manager after all) and what their subordinates...

Wow! I would love to work with you for awhile.  I know I could learn a great deal.

We had something similar happen.  To handle this, we set the parameters in our in our stored procs and triggers to null if no values were passed to them.  Now...

pwdencrypt() does encrypt, but the article at http://www.theregister.co.uk/2002/07/08/cracking_ms_sql_server_passwords/ 

explains how they can also be cracked.

With a DTS, is a cursor-based trigger necessary?  Cursors are very slow, so wouldn't a set-based trigger work better?

Thank you both so much.  I now understand what the function is doing.  Very clever procedure!

  Thank you so much.  I will dive right into these!!!