CONCAT

Concatenates multiple text strings into a single string

Description	The CONCAT() function allows you to combine multiple text strings into one, which can be useful for creating dynamic labels, combining names, or constructing sentences from text fragments.
Syntax	CONCAT(text1, text2, …)

1. text1, text2, ... : These are the text strings you want to concatenate. You can include multiple text strings separated by commas.

Example

Table

Column 1	Column 2	Column 3
Hello	,	world!
This	is a	test
Savant	is	amazing

Function

CONCAT(`Column 1`, `Column 2`, `Column 3`)

Results

CONCAT (text)
Hello, world!
This is a test
Savant is amazing