Text & patterns
Scalar
replace()
Replaces any occurrences of the source with target in string.
Arguments & returns
replace(string, source, target)
Scalar
| Overload link | string | source | target |
Returns |
|---|---|---|---|---|
| #01 | VARCHAR | VARCHAR | VARCHAR |
VARCHAR |
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
In other engines
Prestoreplace()
REPLACE(subject, pattern)
In HaybarnREPLACE(subject, pattern, '')
Snowflakereplace()
REPLACE(subject, pattern)REPLACE(subject, pattern, '')