Yes. The functions are PWENCRYPT and PWCOMPARE. This basically allows the ability to encrypt a value on an insert/update and offer a comparison of the value on a select. There isn't a decryption function available. Here are a few T-SQL statements to illustrate how pwencrypt/pwcompare work: create table #MetroTest ( UserLogIn varchar(10), UserPass nvarchar(256) ) insert #MetroTest (UserLogIn,UserPass) values ( 'MaryMary', PWDENCRYPT('QuiteContrary')) select UserLogIn, password = 'QuiteContrary', PWDCOMPARE('QuiteContrary', ......