encryption

[Kenneth Brody]

Quoting Richard Kreiss (Thu, 15 Feb 2007 12:16:08 -0500):

> Question:
>
> The same Credit card number encrypted in two file using the same
> encryption method.
>
> Can I compare the encrypted value in processing to see if they match or
> do I need to unencrypted both and then compare?

The same data, encrypted using the same method, with the same key,
will encrypt to the same value.  No other input data, using the same
method and key, will encrypt to the same value.

You will, however, need to use COMPARE() to do a case-sensitive
comparison, on the very unlikely chance that they encrypted to the
same letters, but different case.  (Of course, only equality can be
checked.  Others, like "greater than", have no meaning on encrypted
data.)

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com