How to put brackets around a SQL result, via SQL query?
<p>I have a <code>sql</code> query inside the jasper report and I want to put brackets around a specific generated result from it . </p>

<p>This is sql query,</p>

<pre><code>SELECT `idMedication`,`idPatient`, `Drug` from medication
</code></pre>

<p>I want to put a brackets around <code>Drug</code> from the result, and I require to do it via the SQL code it self.</p>

<p>For an example, at the moment a drug is displayed like "Paracetamol" but I require it as "<code>(Paracetamol)</code>" </p>

<p>Any idea on how to do this?</p>