title: How to replace semicolons?
body: <p>I have an SQL <code>SELECT</code> query that's grabbing some data from my database. I need to replace a certain word that contains a semicolon in my <code>SELECT</code> query. Exactly this:</p>
  
  <pre><code>REPLACE(Table.Field,'&amp;quot;','') AS Field1
  </code></pre>
  
  <p>The error I'm getting reads</p>
  
  <blockquote>
    <p>Unclosed quotation mark after the character string '"'.</p>
  </blockquote>
  
  <p>So I think the semicolon is terminating the query. How can I escape that semicolon?</p>
  
  <p>I tried backslashes and using double quotes.</p>
  
  <p>Some sample data and expected output, as requested</p>
  
  <hr>
  
  <h2>Sample data</h2>
  
  <pre><code>Field
  &amp;quot;Hello&amp;quot;
  &amp;quot;Goodbye&amp;quot;
  </code></pre>
  
  <hr>
  
  <h2>Expected output</h2>
  
  <pre><code>Field1
  Hello
  Goodbye
  </code></pre>
  
  <hr>
  
  <h2>Full Query</h2>
  
  <pre><code>SELECT REPLACE(Table.Name,';','') AS Name,
      SUM(Table.Quantity) AS Quantity, 
      SUM(Table.Price*Table.Quantity) AS Price 
  FROM Table 
  GROUP BY Name
  </code></pre>