Subject Querying Encrypted fields?
Author Lee Jenkins
Hello all,

Visa/Mastercard regulations dictate that credit card information must be
encrypted in applications like my company's POS software when stored in the
database. Now, I'm tring to figure out how I can do a search through my FB
1.51 DB when the data is encrypted.

Is there anything short of spinning through the entire table and decrypting
on the fly? I was thinking of storing the last four digits in a separate,
indexed field to make searching faster.

Thanks to all,