title: Update Field with Special Character ' (single quote)
body: <p>I am workign with SQL Server 2008 and have to update one field (FIELD_NAM) which contains values of this format: </p>
  
  <ul>
  <li>First value in the field: 'abc', 'efg', 'xyz'</li>
  <li>Second value in the field: 'aaaaa', 'bbbb', 'vvvvvv'</li>
  </ul>
  
  <p>I tried with the following statement:</p>
  
  <pre><code>UPDATE Table
  SET FIELD = 'ttttt', 'kkkk', 'mmmmmm'
  WHERE ID = 1
  </code></pre>
  
  <p>(only one row and one field/column has to be updated)
  The error I got is </p>
  
  <blockquote>
    <p>Incorrect syntax near 'ttttt'</p>
  </blockquote>