concat function

The concat function concatenates all its arguments and displays the concatenated string as output.

returnvalue concat (source,[source*])
source ::= any*
returnvalue ::= string

Example: Display the routing of a customer with a particular ticket number as "The route for passenger_name is ...".

SELECT concat("The route for passenger ",fullName , " is ", bag.baginfo[0].routing)
FROM baggageInfo bag 
WHERE ticketNo=1762376407826

Output:

{"Column_1":"The route for passenger Dierdre Amador is JFK/MAD"}