PASSWORD('qwert')

[DAW.THAZIN-ZAW-WIN]

Hello,
I've created the user table with varchar(8) for password field. And I 
inserted the data for this field as PASSWORD('qwert') for example, it 
showed as 51d140c551.
When I do SELECT for the logon user and match the 2 passwords, it showed 
the passwords are not matched even though they are the same.
SELECT id, name, password FROM User;
id      name    password
10      John    51d140c551
How can I check this ? Is there anyway to see the uncoded password ?
Thanks & Regards,
Thazin.