REPLACE

Replaces every occurrence of a substring with another string.

Syntax

REPLACE( <string>, <from>, <to> )

Argument	Description
`<string>`	The text to change.
`<from>`	The substring to find. Matched exactly, with case.
`<to>`	The text to put in its place. Use `''` to delete it.

Text. NULL when any argument is NULL. <string> unchanged when <from> is empty.

For a pattern, or to match without case, use REGEXP_REPLACE.
On large tables the engine runs it in the data store when <from> is a non-empty literal; otherwise it runs after the rows are read.

SELECT c.key, REPLACE(c.phone, ' ', '') AS phone FROM Customer c

key	phone
C-104	+61290001234

Nested calls replace several substrings:

SELECT f.path, REPLACE(REPLACE(f.path, '_', ' '), '/', ' > ') AS label FROM tables.drive.file f

path	label
finance/annual_report.pdf	finance > annual report.pdf