title: Encrypt a column in SQL Server
body: <p>I have a table <code>TblUserLogin</code> with columns <code>LoginID int</code>, <code>Password varchar(50)</code>, <code>LoginUserName varchar(150)</code>, <code>Designation varchar(100)</code>.</p>
  
  <p>My requirement is that whenever we are using <code>select</code> statement to this table we are able to see the password which is entered (which is sensitive information). </p>
  
  <p>Is there any way so that we can encrypt the password column so that when ever we use <code>select</code> statement that information will be seen in an encrypted way and will not affect the code which is accessing the password column or inserting new password?</p>
  
  <p>In simple words when "The password column shown as encrypted when it is accessed from Management Studio using <code>select</code> statement, but when accessed programatically it returns the actual non-encrypted password".</p>