title: MS SQL - Fastest way to adding $2 to a varchar column with numbers
body: <p>Is there a faster way to do this directly in MS SQL ?</p>
  
  <p>I also get an error saying: <strong><em>"Query-based update failed because the row to update could not be found. "</em></strong></p>
  
  <pre><code>    strQuery = "SELECT FEE from FEES_OlderImport"
      objRS.open strQuery
  
  While not objRS.EOF
  '// UPDATE EACH TABLE HERE
  objRS("FEE")=objRS("FEE")+2
  objRS.Update
      objRS.MoveNext
  Wend
  objRS.Close
  </code></pre>
  
  <p>THANKS :)</p>