quote:
Encrypt function in T-SQL is fine what about Decryption of encrytion columns.kindly tell us how to do it!
As I mentioned in the article, the only way to decrypt is with a comparion techinque with a WHERE clause. That's why if you would like to use a more advanced encryption/decryption system, you may have to resort to COM. Les Smith will be having some excellent articles coming out this week and next about how to use this.
Brian Knight
http://www.sqlservercentral.com/columnists/bknight
Brian Knight
Free SQL Server Training Webinars