String

LTRIM

DuckDB

Menghapus karakter dari sisi kiri (awal) string. Secara default menghapus whitespace, bisa dikustomisasi untuk karakter tertentu.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

LTRIM(string [, characters])

Parameter

stringVARCHARwajib

String yang akan di-trim dari kiri

charactersVARCHARopsional

Karakter-karakter yang akan dihapus. Default: whitespace

Contoh Penggunaan

Menghapus Spasi di Awal

SQL

1 SELECT
2   '>' || LTRIM('   Hello World') || '<' as trimmed;

Menghapus spasi di awal string.

Hasil

trimmed
>Hello World<

Menghapus Leading Zeros

SQL

1 SELECT
2   product_code,
3   LTRIM(product_code, '0') as clean_code
4 FROM (
5   SELECT '000123' as product_code UNION ALL
6   SELECT '00456' UNION ALL
7   SELECT '0007'
8 );

Menghapus nol di awal kode produk.

Hasil

product_code	clean_code
000123	123
00456	456
0007	7

Menghapus Prefix Characters

SQL

1 SELECT
2   raw_value,
3   LTRIM(raw_value, '$#') as clean_value
4 FROM (
5   SELECT '$$$100' as raw_value UNION ALL
6   SELECT '###200' UNION ALL
7   SELECT '$#$300'
8 );

Menghapus karakter $ dan # dari awal.

Hasil

raw_value	clean_value
$$$100	100
###200	200
$#$300	300

Fungsi Terkait

TRIMRTRIM

Kembali ke DuckDB Functions

1	SELECT
2	product_code,
3	LTRIM(product_code, '0') as clean_code
4	FROM (
5	SELECT '000123' as product_code UNION ALL
6	SELECT '00456' UNION ALL
7	SELECT '0007'
8	);

1	SELECT
2	raw_value,
3	LTRIM(raw_value, '$#') as clean_value
4	FROM (
5	SELECT '$$$100' as raw_value UNION ALL
6	SELECT '###200' UNION ALL
7	SELECT '$#$300'
8	);