James,
You can use

INSERT INTO YourTable (PasswordField) VALUES (CAST('asd' AS VarBinary(200))

and reverse

SELECT CAST(PasswordField AS VarChar(200)) from YourTable where ...

James,
I like CA,
but IMO you need again use binary, varbinary or image data type in SQL.


>Thanks Vladimir,
>
>I am using varchar(200) and I was afraid that was the problem. I am using SPT and I have not found a way to work with the binary type. I guess I will have to switch this table to CA.
>
>Thanks again.
>
>>>Hi all,
>>>
>>>I am using Craig Boyd's vfpencryption.fll to encrypt passwords and save them in a SQL type database. It seems that once in a while I have a problem that one or more of the characters that the fll creates will not work and the update gets rejected. I tried to copy the update statement into ISQL and half of the password screen was truncated. Is there a way to make the work and still be able to decrypt the password?
>>>
>>>Tahnks for your help.
>>
>>Hi James,
>>What Data Type is your column in SQL for passwords ? Use binary type.
>>
>>HTH