title: MSSQL update only if current value is greater than previous
body: <p>I have database with fields
  id,studentname, highestmarks</p>
  
  <p>Now the student gets new marks, I want to update the database with new marks, but only if new marks are greater than the value stored in field "highestmarks" else I don't want to update.</p>
  
  <p>In MySQL this can be achieved using GREATER function, but I don't know about MS-SQL</p>