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