> 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,
>
> Lee

The names don't have to be encrypted... just encrypt the number/expiry etc
and you can still search the name
Alan