Learner44 (7/23/2013)
Hi Sean..I want to make it more complex and secure..
like reading each Accountnumber and convert each character into some special character..
is it worth to do it ..from your point of view..?
thanks.
The problem here is that you will end up with a high risk of collisions. It is not super secure but it certainly does an adequate job of disguising the information. To be certain, it is only going to hide the actual value of that column. It does not protect any of the other information. I would maybe look into redesigning parts of your system so that the sensitive data is in only one table instead of all over the place.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/