I need to encrypt a field that contains confidential information, but I also
need to decrypt that field later. This must be reasonably strong, not just a
rotate or simple addition.

Thanks,
_harry

Which version of SQL Server are you using? In SQL 2005, you can use the
built-in encryption mechanisms using master keys & certificates. In SQL
2000, you'll have to write up your own encrytion routines. Check out
www.sqlsecurity.com for some pointers.

Best way to insert data into tables without primary keys
What is new in Sql Server 2005 cursors?
error converting datatype varchar to numeric
Update Query in SQL 2005 with inner join
Select Query Help Needed