## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> REPLACE[REPLACE]:::quoted replace -->| | REPLACE REPLACE --> End((END)) ``` ## Purpose The `REPLACE` SQL function changes a given text by replacing all occurrences from an ordered list of texts by their associated replacement texts. Parameters: - Input: the text to change. - Old text 1: the text to be replaced. - New text 1: the replacement text. - Old text n: additional texts to be replaced. - New text n: additional replacement texts. Returns: A text with all old texts replaced by their new text in the order they occur in the list.