I am working on a password scheme, however I read in the MySql manual that if encrypt isn't available, it will return a null set. This is causing a problem with something I am working on using a windows 2000 machine (with the recent version of MySql for windows platforms), is there a similar function that I can use? or any other suggestions? or I'm a just doing something wrong? The statement I am using is: mysql> select ENCRYPT("hello"); +------------------+ | ENCRYPT("hello") | +------------------+ | NULL | +------------------+ 1 row in set (0.00 sec) I may have found a solution using the PASSWORD function, however de-crypting it may be handy _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php