Show special characters in concat with db2 sql
<p>I am running query like this for db2 sql</p>

<pre><code>SELECT CONCAT(CONCAT('Order_no is =', Order_no), ' for line') FROM orders;
</code></pre>

<p>And result is coming like this:</p>

<pre><code>Order_no is =123456 for line
</code></pre>

<p>But I want to fetch result as</p>

<pre><code>Order_no is ='6640354' for line
</code></pre>

<p>I need to apply special characters to output, so can you please help me in this.</p>