# REPLACE

(See [REPLACE](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/replace.md) for the DML command.)

Replaces all occurrences of a substring by another string.

## Syntax

```sql
REPLACE(string, old_string, new_string);

```

## Arguments

* string: any string
* old\_string: the string to be replaced
* new\_string: the replacement string

## Remarks

* SingleStore Helios uses case-sensitive match to search for the `old_string`

## Return Type

String

## Examples

The example below replaces a string in the `name` column of the `company` table using the `REPLACE` function.

```sql
CREATE TABLE rep_company (name varchar(30));
INSERT INTO rep_company values ("Zumiez Inc."), ("Orange.com"), ("Pomegranate Corp."), ("FruitCompany Consolidated");
```

```sql
SELECT name FROM rep_company WHERE name LIKE "Zumiez Inc.";

```

```output

+------------------------------+
| NAME                         |
+------------------------------+
| Zumiez Inc.                  |
+------------------------------+
1 row in set (242 ms)

```

```sql
SELECT REPLACE(name,'Inc.','Corp.') FROM rep_company WHERE name LIKE "Zumiez Inc.";

```

```output

+------------------------------+
| REPLACE(name,'Inc.','Corp.') |
+------------------------------+
| Zumiez Corp.                 |
+------------------------------+
1 row in set (1.34 sec)

```

The `REPLACE` function can also be grouped with other string functions. An example of combining `REPLACE` with `GROUP_CONCAT` function is shown below.

```sql
CREATE TABLE rep_Emp (Name varchar(50), City varchar(50));
INSERT INTO rep_Emp values("Adam", "Chicago");
```

```sql
SELECT * FROM rep_Emp;

```

```output

+-------------------------------------------------------------+
| Name                         | City                         |
+-------------------------------------------------------------+
| Adam                         | Chicago                      |
+-------------------------------------------------------------+
1 row in set (1.05 sec)

```

```sql
SELECT GROUP_CONCAT(Name, '-', City) FROM rep_Emp;

```

```output

+------------------------------+
| GROUP_CONCAT(Name, '-', Ci...|
+------------------------------+
| Adam-Chicago                 |
+------------------------------+
1 row in set (991 ms)

```

```sql
SELECT GROUP_CONCAT(REPLACE(Name, 'Ad', 'S'),'-', City) FROM rep_Emp;

```

```output

+------------------------------+
| GROUP_CONCAT(REPLACE(Name,...|
+------------------------------+
| Sam-Chicago                  |
+------------------------------+
1 row in set (960 ms)

```

***

Modified at: January 22, 2026

Source: [/cloud/reference/sql-reference/string-functions/replace/](https://docs.singlestore.com/cloud/reference/sql-reference/string-functions/replace/)

(An index of the documentation is available at /llms.txt)