replace()

Replaces any occurrences of the source with target in string.

Arguments & returns

Scalar

Overload link	`string`	`source`	`target`	Returns
#01	`VARCHAR`	`VARCHAR`	`VARCHAR`	`VARCHAR`

SELECT replace('hello', 'l', '-');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

REPLACE(subject, pattern)

In DuckDB

REPLACE(subject, pattern, '')

REPLACE(subject, pattern)

In DuckDB

REPLACE(subject, pattern, '')