Storing the passwords??

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  February 3, 2006 at 9:21 am

  #189071

  Hi,

  Can anyone help me that: ' I want to store the passwords in the form of * rather than the original letters.

  is there any way to convert it??

  Thanks,

  Noman

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  February 3, 2006 at 9:42 am

  #618723

  There is no way to "Mask" the value natively in sql. There are several articles that introduce encrypting.

  Do a search on this site, and you will find tons of information.

  I always make the application encrypt the data, because they can control encryption level, and keys better than in a db.

  http://www.sqlservercentral.com/columnists/bknight/encryptfunction.asp