title: Escape special characters for Oracle and SQL Server in the same query
body: <p>I have following query:</p>
  
  <pre><code>SELECT *
  FROM PRODUCTS
  WHERE REDUCTION LIKE '50%'
  </code></pre>
  
  <p>I'm required to use the LIKE clause. This query needs to run on both Oracle and SQL Server.</p>
  
  <p>Now there is an issue because I want to match all products with a reduction of 50%. But the data might contain a reduction of 50.50%. Because '%' is a special character it matches both of them.</p>
  
  <p>I want to escape all special characters, like the <strong><code>%</code></strong> in my query so that I only get the products with 50% reduction.</p>
  
  <p>Is there an uniform solution to escape special characters on a dynamical way for both Oracle and SQL server?</p>
  
  <p>Using a backslash is not a solution, because we don't know in practice what the input will be.</p>