Friday, January 25, 2013 7:30 PM
My scenario is , in our dB we store ssn as encrypted values. we would like to search the SSN when user enters the value of ssn.
it takes lot of time to decrypt and match the ssn in million records. Please provide some tips and tricks to handle this situation.
Friday, January 25, 2013 7:35 PM
If you need to do an exact search, you would simply first encrypt the value and then search for any record with the same encrypted value. In short, in short of decrypting millions of fields, you are encrypting the input and searching based on that.
I don't think there is any option for partial search, You can have requirements like search by last 4 digits, in which case, either store the last 4 digits in a separate colun [clear or encrypted, as your security guideline recommends]
- Proposed As Answer by Naomi NMicrosoft Community Contributor, Moderator Friday, January 25, 2013 9:51 PM
- Marked As Answer by Kalman TothMicrosoft Community Contributor, Moderator Saturday, February 02, 2013 9:59 PM