"konay" <conie.agno@equitablepcib.com> wrote in message
news:06b801c36b8d$c6aec890$a601280a@phx.gbl...
> Does SQL Server support Encryption and Decryption of
> column?

Vishal Parkar wrote:

>No,
>But there are 2 undocumented password encryption function
>pwdencrypt/pwdcompare by which you can encrypt and
>decrypt a string.
>
>Following is the example.
>
>declare @x varbinary(500)
>declare @ret int
>select @x=convert(varbinary(500),pwdencrypt('check'))
>select pwdcompare('check',@x, 0)
>
>You can use pwdencrypt in a update/insert trigger to
>encrypt the values of a table's column. While decrypting
>you'll have to use pwdcompare which will return 0 or 1 on
>the basis of failed or successfull comparison
>respectively.
>
>for more information visit
>http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9809
>
>since these functions are undocumented i wont suggest you
>using them. you may go for third party encryption, visit
>following url
>
>http://www.activecrypt.com/faq.htm
>
>- Vishal
>
>
>>-----Original Message-----
>>Does SQL Server support Encryption and Decryption of
>>column?
>>.
>>
>>
>>