## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR Start((START)) --> INSTR[INSTR]:::quoted INSTR --> End((END)) ``` ## Purpose The `INSTR` SQL functions gets a number which is a position of the first occurrence of substring in the text. Parameters: - Text: text to be searched. - Substring: text to search for. - StartPosition (optional): position of text to start searching. - occurrence (optional): return the position of the occurrence. Returns: the position of the substring inside the original text.