Barrier Barrier - 7 months ago 10
SQL Question

How to put brackets around a SQL result, via SQL query?

I have a

sql
query inside the jasper report and I want to put brackets around a specific generated result from it .

This is sql query,

SELECT `idMedication`,`idPatient`, `Drug` from medication


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

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

Any idea on how to do this?

Answer

You can use the CONCAT function :

SELECT `idMedication`,`idPatient`, CONCAT('(', `Drug` ,')') AS Drug from medication