Timothy
I never used the type before, but working with it now in a project. This project requires encrypted fields in the database for privacy-sensitive information.
I'm using ENCRYPTBYPASSPHRASE for that now and as you might guess this function transforms varchar data into varbinary type.
I think this type of encrypted storage will become more and more important!
Regards
Albert