title: Escape ampersand with SQL Server
body: <p>I have this SQL-Server query</p>
  
  <pre><code>UPDATE qryPETEUR_frmPricingModel() SET G&amp;A = '68442.0000' WHERE comp_id = '10004'
  </code></pre>
  
  <p>Which fails because <code>Incorrect syntax near '&amp;'</code></p>
  
  <p>The query works when I change the field being edited to something without an ampersand, so I think the ampersand is the problem.  Unfortunatly I am stuck having to use the use the field <code>G&amp;A</code> and can't change it.</p>
  
  <p>What can I do to get this query working.  I think I have to escape the ampersand, but I can't figure out how.  I have tried adding \ slash in front of it as well as adding <code>ESCAPE '\'</code> to the end of the query, but nothing worked.</p>
  
  <p>I am also using Code Igniter if that helps.</p>