> 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...

Lee