title: How to append to a existing record in SQL?
body: <p>Can someone tell me how to append in SQL? I've going around all day trying to figure this out. This is what I have so far:</p>
  
  <pre><code>update table1 
  set field1 = field1 + '123456' 
  where field2 = '12'
  </code></pre>
  
  <p>Sorry, I forgot to mention that I'm updating more than one field in the statement.</p>