InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:23:20 GMT20http://www.sqlservercentral.com/Forums/Topic423515-360-1.aspxTake a look at the [i]EncryptByPassPhrase[/i] and [i]DecryptByPassPhrase[/i] functions. The Books Online links (which have examples):[url=http://msdn2.microsoft.com/en-us/library/ms190357.aspx]EncryptByPassPhrase()[/url][url=http://msdn2.microsoft.com/en-us/library/ms188910.aspx]DecryptByPassPhrase()[/url]Mon, 19 Nov 2007 06:19:28 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic423515-360-1.aspxi have already gone through the microsoft article....i want encryption by password method.... i dont want to create certificates...just creating keys, opening them.. assigning it to column(encrypt it)...and finally decrypt itMon, 19 Nov 2007 05:23:33 GMTAmit kulkarni-491236http://www.sqlservercentral.com/Forums/Topic423515-360-1.aspxBooks online has a good example: [url]http://technet.microsoft.com/en-us/library/ms179331.aspx[/url]Regards, AndrasMon, 19 Nov 2007 05:17:06 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic423515-360-1.aspxhi iam having a table called 'Users' having password column.It already contains some data.i want to encrypt the password field for exisiting record and for new records which may be added in future.(for security purpose)please give me detailed Step by step description for data encryptionplease dont provide only linksMon, 19 Nov 2007 05:09:46 GMTAmit kulkarni-491236