Hi,
To store (and use) our users password in the database, we use the couple of function ENCRYPT and DECRYPT.
To encrypt the password we use the following instruction :
UPDATE USR SET UsrPass = ENCRYPT('toto', 'TheVeryLongKey', '(AES256') WHERE ...
...