how to encrypt a password field in sql server2005

Often a oneway "encryption" is sufficient: add some "salt" to the clear text password, then hash it with MD5, SHA1 or other hash functions. When the user tries to log in, just follow the same procedure and compare the "encrypted" values.
If you need to retrieve the original clear text password from the value stored in the database, you need a real encryption method. The System.Security.Cryptography namespace offers some methods.

you Can use this coding for making secure password

string s = "Foo bar";
string s1 = Convert.ToBase64String(Encoding.Unicode.GetBytes(s));

' And back...
string s2 = Encoding.Unicode.GetString(Convert.FromBase64String(s1));

thanks

q=encrypt+password+sql+server+2005[^]