title: concatenate two column values
body: <p>I'd like to run a query on a table where I concatenate the the value of one column with another.</p>
  
  <p>Something like the following (javascripty attempt):</p>
  
  <pre><code>UPDATE table
  SET items = items+","+item1
  WHERE item1 != "No Data" || item1 != "";
  </code></pre>
  
  <p>Is this possible to do in the database or do I need to be doing it in the middleware?
  Any pointers again much appreciated.</p>