title: How to allow search using CONTAINS on 'B&B' without getting the prompt for 'Enter Substitution Variable' because of the & and get only 'B&B'
body: <p>I am performing a search of a CLOB that is Globally indexed so I can use a CONTAINS function.  The phrase I am searching for is 'B&amp;B'.  I have tried multiple ways to escape the &amp; so it won't be looked at as a prompt for user input.  I am unable to do it.</p>
  
  <pre><code>select * from table where contains(txt, '({B&amp;B})')&gt;0;--this gives me substitution variable prompt
  
  select * from table where contains(txt, '({B}{&amp;}{B})')&gt;0;--this finds 'B B'
  
  select * from table where contains(txt, '(B{&amp;}B)')&gt;0;--this finds 'B B'
  
  select * from table where contains(txt, '({B&amp;B})')&gt;0;--this gives me substitution variable prompt
  
  select * from table where contains(txt, '({B&amp;}B)')&gt;0;--this finds 'B B', 'B.B', 'B&amp;B'
  
  select * from table where contains(txt,'NEAR (({B&amp;},(B)),1)') &gt; 0;--this finds 'B B', 'B.B', 'B&amp;B'
  
  select * from table where txt like '%B&amp;B%';--this gives me substitution variable prompt
  </code></pre>
  
  <p>I can't deactivate the ability to use substitution variable prompt, so this must be done in code.</p>
  
  <p>I need to ignore all occurrences of 'B B', 'B.B'  and have it return only the rows that have 'B&amp;B' in this field.</p>