overlay()

Replaces a substring of string starting at character start with replacement. If count is not specified, it defaults to the length of replacement. Note that a start value of 1 refers to the first character of the string.

Reference: Haybarn WASM 2.0.0-rc12

Arguments & returns

2 overloads

overlay(string, replacement, start)

Scalar
Overload link stringreplacementstart Returns
#01 VARCHARVARCHARBIGINT VARCHAR

overlay(string, replacement, start, count)

Scalar
Overload link stringreplacementstartcount Returns
#02 VARCHARVARCHARBIGINTBIGINT VARCHAR

Example

1 more ↓
overlay example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

overlay example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.