how to put % in string
<p>I have tried using <code>'%%'</code> and <code>'%'</code> already, none of these working in the below scenario.</p>

<p>The output of query is:</p>

<pre><code>UPPER('field') LIKE UPPER('string')
</code></pre>

<p>But I want the output as:</p>

<pre><code>UPPER('field') LIKE UPPER('%string%')
</code></pre>