## Syntax
```mermaid
%%{init: {
'theme': 'base',
'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' },
'themeVariables': {
'fontSize': '11px',
'fontFamily': 'Arial'
}
}}%%
flowchart LR
Start((START)) --> LTRIMTEXT[LTRIMTEXT]:::quoted
LTRIMTEXT --> End((END))
```
## Purpose
The `LTRIMTEXT` SQL function trims the left side of a text by a list of trim texts. When the text starts with a trim text, the trim text is removed.
See also [[RTRIMTEXT]].
Parameters:
- Text (`varchar2`): text to be trimmed.
- Trim Text (optional, `varchar2`): text(s) we want to left trim from Text. Defaults to whitespace.
Returns: the trimmed text.
## Examples
The following example trims the text `The ` from the left side of `The Invantive`:
```sql
select ltrimtext('The Dog', 'The ')
-------------------
Dog
```
The following example trims the repeated text `The ` from the left side of `The The Invantive`:
```sql
select ltrimtext('The The Dog', 'The ')
-------------------
Dog
```