LTRIM

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

See also:

Analyze Syntax

func.ltrim(<string>, <trim_string>)

Analyze Examples

func.ltrim('xxdatabend', 'x') +--------------------------------+ | func.ltrim('xxdatabend', 'x') | +--------------------------------+ | databend | +--------------------------------+

SQL Syntax

LTRIM(<string>, <trim_string>)

SQL Examples

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