title: LotusScript - How to escape double quotes in the SELECT statement?
body: <p>I have a multiple documents which are containing the field named <strong><em>organization</em></strong>.</p>
  
  <p>Almost every second document contains double quotes in this field, for example: Medical Center "James Goodwin Corp." e.t.c </p>
  
  <p>I have a search query with the name of some organization, which also contains quotes and trying to use this name in the search query to find all needed documents.</p>
  
  <p>I have tryed many variants and each time I am getting the query syntax error about double quotes. </p>
  
  <p>Can you please give some small example or some advise how to escape double quotes in the SELECT statement? </p>
  
  <p>Thank you!</p>
  
  <p><strong>Update:</strong></p>
  
  <p>Yes, I am using Replace function like this:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>searchValue = Replace(docByUi.search(0),{"},{|"|})
  </code></pre>
  
  <p>to change this double quotes to |"|.
  And I am getting an error <a href="http://clip2net.com/s/3Plp4V3" rel="nofollow noreferrer">in my select query</a>
  Or maybe I am wrong in something?</p>
  
  <p><strong>Update #2:</strong></p>
  
  <p>My query looks like this:</p>
  
  <pre class="lang-none prettyprint-override"><code>query = {Form="Person" &amp; @Contains(} &amp; docByUi.fields(0) &amp; {;"} &amp; searchValue &amp; {")}
  </code></pre>
  
  <p>I meaned that I am already using {} to create a part-to-part query.</p>