Re: How to encrypt a column in SQL Server

• AJ-92543

  SSC Eights!

  Points: 912

  More actions

  January 28, 2005 at 9:53 am

  #163521

  Hi everyone,

  How can you encrypt a column in SQL Server?? I have a text box in Access when user types in his/her password I would like the field to display something like **** in the text box. The password field is a field in a table on SQL Server.

  I'm using AC2K and SQL Server 2K.

  Thanks in advance.

• Kathi Kellenberger

  SSChampion

  Points: 11811

  More actions

  January 30, 2005 at 3:54 pm

  #539667

  I this case, the data won't be encrypted in SQL, but it will be displayed as ***** in the text box when using a form.   Set the "Input Mask" value of the text box to PASSWORD . 

  Aunt Kathi Data Platform MVP
  Author of Expert T-SQL Window Functions
  Simple-Talk Editor