replace
function
Applies to: Databricks SQL Databricks Runtime
Replaces all occurrences of search
with replace
.
Syntax
replace(str, search [, replace] )
Arguments
str
: ASTRING
expression to be searched.search
: ASTRING
expression to be replaced.replace
: An optionalSTRING
expression to replacesearch
with. The default is an empty string.
Returns
A STRING.
If you do not specify replace
or is an empty string, nothing replaces the string that is removed from str
.
Examples
> SELECT replace('ABCabc', 'abc', 'DEF');
ABCDEF