Previous Next JavaScript must be enabled to correctly display this content

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