title: How to escape ampersand in TOAD?
body: <p>When I try to insert a value which has '&amp;' in TOAD I get a prompt for a substitution variable.</p>
  
  <p>So when I try:</p>
  
  <pre><code>insert into x values('hello &amp; world'); 
  </code></pre>
  
  <p>it throws a prompt for substituting the variable 'world'.</p>
  
  <p>I have tried right clicking in the editor and  disabling prompt for substitution variables but this seems to work only for Execute Statement (<kbd>F9</kbd>)  It doesn't work for Execute as script(<kbd>F5</kbd>).</p>
  
  <p>I am also aware of using <code>chr(38)</code> like:</p>
  
  <pre><code>insert into x values('hello '||chr(38)||'world');
  </code></pre>
  
  <p>but I do not want this.
  Is there something else that will help me run the script?</p>