>Gerry,
>
>>But with index
>>index on NAMEFIELD tag NAMEFIELD
>>the order it's correct?
>>Or caracther crypting change ordering information?
>
>Oops! You are right! I'm not sure how you could encrypt your indexes AND still maintain sort order.
>
>Very Good Question. I don't have an answer.
>
>Malcolm
I think most suggestions I've seen for dealing with this involve encrypting the value you're using for a SEEK or in a WHERE clause and then doing your search against the encrypted data.
Regards,
Jim