sql server data warehouse: HOw to set the field (Password) in sqlServer database to '*'

For example
I key in VB : 12
In SqlServer database should appear : **

Yoir help will be appreaciated

Daniel:
I don't think that this is a datawarehouse question, but nevertheless
In SQLServer it is not possible to individually mask (as in MS Access) or
encrypt a single column as such. You would have to write your own encryption
routine or get one (many are available).
I usually encrypt my passwords and also set proper user rights restrictions
in order to protect the passwords.

Balaji Vasudevan




[quoted text, click to view]