title: update MD5 value not working in sql server
body: <p>I have written a query to update a password using MD5. but the new password is not working, as well as the old password also. Below is the query.</p>
  
  <pre><code>UPDATE tbl_user
  SET password = HashBytes('MD5', CAST(CHECKSUM('abc') AS varchar(32)))
  WHERE login_id = 'user123'
  </code></pre>
  
  <p>Now when i give abc as a password it doesn't work, when i login to my application.</p>