Thu
12
Jul '07
You can use HashBytes to achieve.
Check this for reference: http://msdn2.microsoft.com/en-us/library/ms174415.aspx
Note: for MySQL you have MD5() function
Check this for reference: http://msdn2.microsoft.com/en-us/library/ms174415.aspx
SELECT
HashBytes(‘MD5′, ‘Praveen’),
HashBytes(‘MD5′, ‘PraveeN’),
‘0xD09C2ECC3DFCDC8C8D921B589097FCB1′,
CASE WHEN convert(int,HashBytes(‘MD5′, ‘PraveeN’)) = 0xD09C2ECC3DFCDC8C8D921B589097FCB1
THEN
‘Success’
ELSE
‘Failed’
END
Note: for MySQL you have MD5() function

Leave a passing comment »