## 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 string. Parameters: - String: String to be searched. - Substring: Text to search for. - StartPosition (optional): Position of string to start searching. - occurrence (optional): Return the position of the occurrence. Returns: the position of the substring inside the original string.