---
schema_version: "1"
id: d3e7fca02ea75d6b982f1bf3f99d101af031cd8dd1395770b4a7849a2a293378
title: CONCAT
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/string-func/concat.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/concat.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 507d6d6399df1022dffec21faa5e358d5de649e70085951444658a4fd4f0dd0b
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `CONCAT`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Concatenates the text representations of all arguments, ignoring NULL values.

## Syntax

```sql
concat(<value1> [, value2 [, ...]])
```

## Arguments

### Required

- `<value1>`: The first value to concatenate.

### Optional

- `value2, ...`: Additional values to concatenate.

## Returns

Returns a text value containing all non-NULL arguments concatenated together.

## Considerations

- Unlike the `||` operator, the function ignores NULL arguments.
- Converts all arguments to their text representation.

## Examples

### Concatenate with NULLs

Combine values including NULL.

```sql
SELECT concat('abcde', 2, NULL, 22) AS result;
```

Returns `'abcde222'`. Ignores the NULL.

## Related Documentation

- [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/string.md)