Hi Dick,

MD5 produces 128-bit "fingerprint" or "message digest" of the input. It would be 16 bytes if you store it as binary. Usualy it is stored as 32 bytes hexa-decimal string. Storing it in 128 bytes character field will add extra spaces to it which you've to take into account.

>I have an application that needs to store an encrypted 9-digit number. MD5 provides the necessary one-way encryption we want. I'm using MD5 for VFP from the RSA Data Security. The white paper that came with it didn't give much detail about necessary syntax. I'm am storing the hashed number in a character field,128 bytes in length. I get very inconsitent results when attempting to find a stored number.
>Does anyone out there have any experience with MD5 and VFP? I"m not sure what field types the hashed data should be stored in or the length it should be which may account for my hit-and-miss retrieval attemtps.
>