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 1 - 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"}