I would like to compare the encrypted values just before updating a table containing encrypted records. What would be the best suitable option w.r.t performance and data accuracy?
1) Compare without encrypting the information (Though it works, not sure if its best practice)
2) Decrypt the information, insert into temp table and Compare
______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂