LTRIM

Introduced or updated: v1.2.694

Removes all occurrences of any character present in the specified trim string from the left side of the string.

See also:

• TRIM_LEADING
• RTRIM

Syntax

LTRIM(<string>, <trim_string>)

Examples

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

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