Concatenate Text | TEXT_CONCAT

Syntax

TEXT_CONCAT( [...values] )

Parameters

values
One or more TEXT values. If any of the values are not a TEXT value they will be converted into one with the STRING operation.

Return Value

A new TEXT value with all VALUES joined together.

Description

Join multiple TEXT values into a single TEXT value

Examples

TEXT_CONCAT() # returns ""

TEXT_CONCAT("text") # returns "text"

TEXT_CONCAT("Insta", "Link", ".io") # returns "InstaLink.io"

TEXT_CONCAT(null) # returns ""

TEXT_CONCAT(123, "456", 789) # returns "123456789"