I am running query like this for db2 sql

```
SELECT CONCAT(CONCAT('Order_no is =', Order_no), ' for line') FROM orders;

```

And result is coming like this:

```
Order_no is =123456 for line

```

But I want to fetch result as

```
Order_no is ='6640354' for line

```

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