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