Hi All,
I want to create a user table having userId and password field.
Can any one tell me how to store passwords in sql server field,

In Ms Access there is "INPUT MASK " to hide the password.

You can use binary datatype, it will not directly show you the value.
You can use cast function while inserting text and retreving binary value.
Syntax.
insert into table1 (uid,pwd) values('emp1',cast('mypwd' as binary))

select uid, cast(pwd as varchar)as pwd from table1




urt

SQL Server uses encryption and stores the encrypted data as varbinary. Look up encryption in BOL. There you will find information on EncryptByKey and DecryptByKey to encrypt and decrypt your data.


========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================