Hi,

Client has asked that key fields in their tables be encrypted (native VFP tables). This is fairly easy to do via wwEncryption from WestWind - at least for text data.

For numeric data, the data has to be converted to a string, then encrypted and then stored as a string (same goes for date data).

Question: instead of encrypting the numeric data, is there any other field type that I could convert the data to such that it would obfuscate it (render it less meaningful for the casual hacker) and to save a round trip through converting to string, encrypting and back again?

I thought of storing a log value to the table but I think the amount of decimals stored is going to throw off the conversions.

Anyhow, just thought I would ask in case someone who does more "mathy" stuff knows if VFP has some capability I am not aware of.

Thanks,