title: how to update a column in a table with unique values, but not all the rows, not incremented
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/412101/is-it-possible-to-perform-multiple-updates-with-a-single-update-sql-statement">Is it possible to perform multiple updates with a single UPDATE SQL statement?</a>  </p>
  </blockquote>
  
  
  
  <p>I am updating a table with some new values for a particular column as below, so i am updating table Prepay, column PrepayTransactionDesc, on certain fows indicated by prepayId</p>
  
  <pre><code>update Prepay
  set PrepayTransactionDesc = 'Funded Repeat Voucher 153429'
  where prepayId = 58045
  </code></pre>
  
  <p>It works fine, but i want to do multiple updates.
  I have tried a few different ways but failed. the was i was trying to do it was using CASE when and then.</p>
  
  <p>for instance, i have the following prepayid and prepaytransactiondesc fields</p>
  
  <pre><code>57770   Funded Repeat Voucher 153118
  57771   Funded Repeat Voucher 153119
  57772   Funded Repeat Voucher 153120
  57773   Funded Repeat Voucher 153121
  57774   Funded Repeat Voucher 153122
  57775   Funded Repeat Voucher 153123
  57776   Funded Repeat Voucher 153124
  57894   Funded Repeat Voucher 153276
  57895   Funded Repeat Voucher 153277
  57896   Funded Repeat Voucher 153278
  </code></pre>
  
  <p>How would i do them in 1 go? It cant be that difficult but i seem to be missing something when i try to do the task.</p>