Hash and un-hash
Dear experts,
Please point me to the right direction.
I have a MS SQL table, let's called it "year_end", there is a column with sensitive data called "customer ID", I would like to hash the "customer ID" column by the identity column and then load it into a new table row by row with the hash result. Example:
The "year_end" table:
name varchar(30)
address varchar(30)
customer_ID char(9)
The new "year_end" table:
name varchar(30)
address varchar(30)
customer_ID ???? (hash value)
samjudson posted a reply:
"I'd recommend a MD5 hash of the column. A simple search for "MD5 C#" should provide you with the samples you need."
But I forgot to mention that I have a C# program that needs to access the new "year_end" table and displays the customer_ID on the web page, so I need to "un-hash" the customer_ID. How do I "un-hash"the customer_ID??
|