Encrypted columns and searches (partial and full)

Hi,

For those implementing encrypted columns, what is the recommended approach when allowing users to also do partial searches on encrypted data? (ie email or creditcard info where the tables contain millions of rows). I understand one cannot have the encryption without performance impact, but the searches can be 10 to 20 times as long as when the info is stored in normal char(20) columns. Just looking as a way to try and lessen the impact.

Thanks

Prompted by your question, I just posted a new entry to my blog about how to enable searches on encrypted data. The entry is at:

http://blogs.msdn.com/lcris/archive/2005/12/22/506931.aspx.

Please take a look at it and let us know if you have additional questions.

Thanks
Laurentiu