TRIM_LEADING

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

See also:

• LTRIM
• TRIM_TRAILING

Syntax

TRIM_LEADING(<string>, <trim_character>)

Examples

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

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