How to Encrypt Column in SQL Server?

[mikemat]

Hi all,

I am using ColdFusion MX 7 and Microsoft SQL Server 2000 database. I have a column that contains social security numbers of my users and am feeling the need to encrypt that column.

Trouble is, I have no clue how to do this in SQL Server or how I could display the data from that column in my web app once the column is encrypted.

Can anyone offer any suggestions?

Thanks in advance!

[Newsgroup_User]

Here's one way...
To encrypt:
URLEncodedFormat(Encrypt(yourSStoencrypt, application.encKey)) then
store this value in MSSQL

To decrypt:
Decrypt(URLDecode(yourSStodecryptfromDB), application.encKey)

HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

[mikemat]

Thanks Tim. I'll give that a try.