how to set up password field

[ksbigfoot]

I am setting up a table that is to contain a password field. How do I set the password to be masked?
Thanks

 

[mrdenny]

If using SQL 2000 you'll need to get a third party dll to do the encryption. If using SQL 2005 encryption is native (See FAQ faq962-5964 for sample code).

When saving encrypted data you'll want to save it in a field with a binary data type. The field should be ~2x the largest value you will allow.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com