Hashing

[transparent]

I am interested in creating a stored proceedure which generates a hash of the data stored in a particular row of a table.

How is this done?

 

[HFA]

I suppose that you must do it when you insert data to the table
Do it at Client part of program
i mean,
If you use some programs to access SQL Databases like Delphi,Vb,C++ or some of them make hash there inside your project, use some encryping or decrypting methods to do your desired work.

 

[theoxyde]

HFA is correct. Maybe if/when Yukon arrives with .NET functions available it will be possible on the database end.

 

[transparent]

is it possible.

I just found the function:

pwdencrypt