---
schema_version: "1"
id: 44f0b2a99528c1d6b25cf662e8610fee88ba3f14e89c292f8ddc053132923672
title: String Concatenation Operator (||)
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/concatenation-operator.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/concatenation-operator.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 8669f45562309156d22fc26ac0258a51c6d09e9d98568a293ff982d221c93a08
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# String Concatenation Operator (`||`)

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

Concatenates two strings or a string and a non-string value, returning NULL if either operand is NULL.

## Syntax

```sql
<string> || <right_value>
```

## Arguments

### Required

- `<left_string>`: The first string to concatenate.
- `<right_value>`: The second value to concatenate.

## Returns

Returns a text value that contains the concatenated strings, or NULL if either operand is NULL.

## Considerations

- NULL arguments are NOT ignored. If either operand is NULL, the result is NULL.
- This differs from the `concat` function, which ignores NULL arguments.

## Examples

### Basic Concatenation

Concatenate two string literals.

```sql
SELECT 'Hy' || 'per' AS result;
```

Returns `'Hyper'`.

### Concatenation with NULL

Demonstrate NULL handling.

```sql
SELECT 'Hy' || NULL AS result;
```

Returns `NULL` because one operand is NULL.

### String with Integer

Concatenate a string with a number.

```sql
SELECT 'Value: ' || 42 AS result;
```

Returns `'Value: 42'`.

## Related Documentation

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