Ltrim

String Function

Description

Removes leading characters, including whitespace, from a string.

Click here to navigate to the PostgreSQL docs page for this syntax.

The function Ltrim() is supported on Snowflake.

Grammar Syntax

LTRIM(<expr> , <characters>)

Sample Source Patterns

PostgreSQL

Code

SELECT LTRIM('#000000123', '0#');

Result

123

Snowflake

Code

SELECT LTRIM('#000000123', '0#');

Result

123