Hey, I have encrypted user data in my database using des_encrypt, now when i specify a particular statement as below:

SELECT LOWER( DES_DECRYPT( forename, 'ENCRYPT STRING' ) )
FROM Users

All the results are now returned in lowercase, anybody know what i am doing wrong? or perhaps how another way to do it?

p.s ENCRYPT STRING is a random charater string, not the actual word. Thanks, Matt