LTRIM

Introduced or updated: v1.2.659

Removes specific characters from the beginning (left side) of a string.

See also:

• TRIM_LEADING
• RTRIM

Syntax

LTRIM(<string>, <trim_character>)

Examples

SELECT LTRIM('xxdatabend', 'xx');

┌───────────────────────────┐
│ ltrim('xxdatabend', 'xx') │
├───────────────────────────┤
│ databend                  │
└───────────────────────────┘