How to Encrypt Specific Data Field in SQL 2000 Select Query

[CabaasSalwe]

i have Table colled User it cantains Password Field,
Normaly in Salect Query for this Table, Will retrive All
data Fields in this Table and Password Field all so Displed,

My qeustion is How to encrypt Password Field in Fake Data
ex(********) durring Select Query!

like this..

Id: UserName:Passwod
1 CBS *******
2 VCB *******

Thanks

[Rabbit]

First off, there are almost no situations in which you should store the password. Store the hash instead.

Second, in that rare situation where you should store the password, never store it in plain text. Store it encrypted in the first place.

[NeoPa]

As Rabbit says, storing plain text passwords is a seriously bad idea if you have any security requirements.

These links (AES Encryption Algorithm for VBA and VBScript; RC4 Encryption Algorithm for VBA and VBScript; SHA2 Cryptographic Hash Algorithm for VBA and VBScript) will give an idea, although they are mainly coded in VBA, as to some of the options available.