# concat

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: concat
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/string-functions/concat
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/string-functions/concat.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/string-functions/concat.adoc
description: Use the `concat()` function to concatenate one or more input values into a single result.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/string-functions/concat.md -->

Use the `concat()` function to concatenate one or more input values into a single result. It supports all data types in Redpanda SQL, except `TIMESTAMPTZ`. The output is returned as a concatenation of the input values.

**Special cases:** Skips `NULL` values and returns the concatenation of non-`NULL` inputs. Returns `NULL` only when there are no input rows.

## [](#examples)Examples

### [](#basic-concat-function)Basic `concat()` function

This example uses the `concat()` function to concatenate three values into a single result:

```sql
SELECT CONCAT ('Oxla', '.', 'com') AS "Website";
```

The query returns:

```sql
+------------+
| Website    |
+------------+
| Oxla.com   |
+------------+
```

### [](#concat-function-using-column)`concat()` function using column

This example uses a **payment** table that stores customer payment data:

```sql
CREATE TABLE payment (
  paymentid int,
  custFirstName text,
  custLastName text,
  product text,
  ordertotal float
);
INSERT INTO payment
    (paymentid, custFirstName, custLastName, product, ordertotal)
VALUES
    (9557451,'Alex','Drue','Latte',2.10),
    (9557421,'Lana','Rey','Latte',2.10),
    (9557411,'Tom','Hanks','Americano',1.85),
    (9557351,'Maya','Taylor','Cappuccino',2.45),
    (9557321,'Smith','Jay','Cappuccino',2.45),
    (9557311,'Will','Ritchie','Americano',1.85);
```

```sql
SELECT * FROM payment;
```

This query displays the table:

```sql
+------------+----------------+----------------+--------------+---------------+
| paymentid  | custFirstName  | custLastName   | product      | ordertotal    |
+------------+----------------+----------------+--------------+---------------+
| 9557451    | Alex           | Drue           | Latte        | 2.10          |
| 9557421    | Lana           | Rey            | Latte        | 2.10          |
| 9557411    | Tom            | Hanks          | Americano    | 1.85          |
| 9557351    | Maya           | Taylor         | Cappuccino   | 2.45          |
| 9557321    | Smith          | Jay            | Cappuccino   | 2.45          |
| 9557311    | Will           | Ritchie        | Americano    | 1.85          |
+------------+----------------+----------------+--------------+---------------+
```

This query concatenates values in the `custFirstName` and `custLastName` columns of the **payment** table:

```sql
SELECT CONCAT  (custFirstName, ' ', custLastName) AS "Customer Name"
FROM payment;
```

This displays an output where spaces separate the first and last names.

```sql
+-----------------+
| Customer Name   |
+-----------------+
| Tom Hanks       |
| Lana Rey        |
| Alex Drue       |
| Will Ritchie    |
| Smith Jay       |
| Maya Taylor     |
+-----------------+
```

### [](#concat-function-with-null)`concat()` function with NULL

This example shows how to use the `concat()` function to concatenate a string with a `NULL` value:

```sql
SELECT CONCAT('Talent Source ',NULL) AS "concat";
```

The result shows that the `concat` function will skip the `NULL` value:

```sql
+------------------+
| concat           |
+------------------+
| Talent Source    |
+------------------+
```