Re: How to encrypt a column in SQL Server

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply