![[Google Cloud Documentation]](https://www.gstatic.com/devrel-devsite/prod/v0f3a5b8b76e4a120372a69044e02756e703b6140f9f1812c6e4a0407b19864b7/clouddocs/images/lockup_full_color.svg){kind=link}
![[]](https://docs.cloud.google.com/_static/clouddocs/images/icons/categories/data-analytics-color.svg){kind=link}
Returns text that is the concatenation of two or more fields or expressions.
Sample usage
CONCAT(Campaign, ", ", Campaign Code)
Syntax
CONCAT( X, Y [, Z,...])
Parameters
X- literal text, a field, or an expression containing at least one field.Y- literal text, a field,or an expression containing at least one field.Z- literal text, a field, or an expression containing at least one field.
Notes
- Aggregated fields cannot be used as parameters.
Examples
In the following examples, note that you can use either single quotes or double quotes, but they must be used consistently.
| Example formula | Output |
|---|---|
CONCAT(Campaign, ", ", Campaign Code) |
Summer Sale, SS01 |
CONCAT('Browser: ', Browser, ' OS Version: ', OS version) |
Browser: Edge Version: 85.0.564.44 |