I assume others have been tasked with encrypting passwords in a table. It
appears that sql 7 doesn't allow you to do it when the data is written to
the table. Is that correct?
If so, how are others doing it?
Write your own encryption algorithm for your app that you call before you
insert/update the column and call it after you retrive the column.
Remove "no_spam" from address to email directly
That's because it is not possible.
Bummer, I know. I've been down that road myself.