Raj,

>I am doing this for encrypting the data:
>
>select keytbl
>REPLACE ALL lickey WITH Encrypt(lickey, lcEncryptPassword)


CIPHER50 is a reversable encryption algorithm. Therefore, if you encrypt...

lcEncryptedString=ENCRYPT("myString","myPassword")

you would typically unencrypt like this...

lcPlainText=DECRYPT(lcEncryptedString,"myPassword")

However, you could also unencryt like this...

lcPlainText=ENCRYPT(lcEncryptedString,"myPassword")

Notice I used the "ENcrypt" command to decrypt.

What you may have done is issue your REPLACE command more than once, and therefore the "lickey" field in the table may be holding a plaintext data value instead of an encrypted string.

I would recommend starting from scratch and going one step at a time and use the debugger to check your values each step. It's simple, once you see what's happening.

Guy