ltrim()

Removes any occurrences of any of the characters from the left side of the string. characters defaults to space.

Reference: DuckDB 2.0.0

Arguments & returns

2 overloads

ltrim(string)

Scalar
Overload link string Returns
#01 VARCHAR VARCHAR

ltrim(string, characters)

Scalar
Overload link stringcharacters Returns
#02 VARCHARVARCHAR VARCHAR
ltrim example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

More examples

ltrim example 2
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.

In other engines

ClickHouse

SELECT LTRIM(s), RTRIM(s), TRIM(s)
In DuckDB
SELECT LTRIM(s), RTRIM(s), TRIM(s)

SQLGlot example ↗

Snowflake

SELECT LTRIM(RTRIM(col)) FROM t1
In DuckDB
SELECT LTRIM(RTRIM(col)) FROM t1

SQLGlot example ↗