title: How to put brackets around a SQL result, via SQL query?
body: <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>