> > Hello,
> >
> > Is the encrypted number stored as ASCII? If so, you could just index the
> > encrypted CC number. When you want to query against it, encrypt the CC
> > number in the client and pass the encrypted result as a parameter to the
> > procedure (or query).
> >
> > Perhaps I am missing something, but this seems like it should work.
> >
> > Kevin Lingofelter
>
> Yes, recently I switched to using the TP crypt stuff for the plain text
> encryption it offers. The only thing is that we store ALL track 2 and 3
> data from the credit card which is usually about 100 bytes long
> so I wasn't
> sure about the feasibility of using an index on a field that long...

Oops. Just checked and we do not keep the entire track data in the db.
Only a string which hold credit card number/exp/discretionary data portion
of track 2 data such as:

4005550000000019=0809222040303033

So, as it turns out, that actually IS much smaller data and could be nicely
indexed, no?

Lee