Encrypting a column

Does anyone know how to encrypt a single column in a table and then
decrypt it later? Thanks for any help.
*** Sent via Developersdex http://www.codecomments.com ***In SQL 2005:
*How to: Encrypt a Column of Data*
http://msdn2.microsoft.com/en-us/library/ms179331.aspx
*mike hodgson*
http://sqlnerd.blogspot.com
Gerald Hopkins wrote:

>Does anyone know how to encrypt a single column in a table and then
>decrypt it later? Thanks for any help.
>
>
>*** Sent via Developersdex http://www.codecomments.com ***
>|||Thanks, Mike. So, are you telling me that I need SQL 2005, that SQL 2000
won't allow me to encrypt columns?
Sincerely,
Gerald
*** Sent via Developersdex http://www.codecomments.com ***|||There are third-party data encryption products for SQL Server 2000, but in
SQL Server 2005 data encryption is built-in. And you're not talking column
encryption (declare a column as encrypted) but data encryption (encrypt data
with an encryption function in the insert statement decrypt with an
encryption function during SELECT). Which is more flexible than column
encryption.
Bob Beauchemin
http://www.SQLskills.com/blogs/bobb
"Gerald Hopkins" <geraldh@.sl-tech.net> wrote in message
news:u6LVQkhLGHA.2012@.TK2MSFTNGP14.phx.gbl...
> Thanks, Mike. So, are you telling me that I need SQL 2005, that SQL 2000
> won't allow me to encrypt columns?
> Sincerely,
> Gerald
>
> *** Sent via Developersdex http://www.codecomments.com ***|||Thanks, Bob!
One more reason for the upgrade.
Sincerely,
Gerald
*** Sent via Developersdex http://www.codecomments.com ***