String

TRIM

Snowflake

Menghapus karakter tertentu (default: spasi) dari awal dan/atau akhir string. LTRIM untuk kiri saja, RTRIM untuk kanan saja.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

TRIM(string [, characters]) | LTRIM(string [, characters]) | RTRIM(string [, characters])

stringVARCHARwajib

String yang akan di-trim

charactersVARCHARopsional

Karakter yang akan dihapus (default: spasi dan whitespace)

SQL

1 SELECT TRIM('  hello world  ') as result;

Menghapus spasi di awal dan akhir string.

Hasil

hello world

SQL

1 SELECT
2   LTRIM('  hello  ') as left_trimmed,
3   RTRIM('  hello  ') as right_trimmed,
4   TRIM('  hello  ') as both_trimmed;

Perbandingan LTRIM (kiri), RTRIM (kanan), dan TRIM (keduanya).

Hasil

LEFT_TRIMMED	RIGHT_TRIMMED	BOTH_TRIMMED
hello	hello	hello

SQL

1 SELECT
2   TRIM('###hello###', '#') as trim_hash,
3   LTRIM('000012345', '0') as trim_leading_zeros;

Menghapus karakter hash dan leading zeros.

Hasil

TRIM_HASH	TRIM_LEADING_ZEROS
hello	12345

SQL

1 UPDATE customers
2 SET
3   name = TRIM(name),
4   email = LOWER(TRIM(email))
5 WHERE name != TRIM(name) OR email != LOWER(TRIM(email));

Membersihkan data customer dengan trim dan lowercase untuk email.

1	UPDATE customers
2	SET
3	name = TRIM(name),
4	email = LOWER(TRIM(email))
5	WHERE name != TRIM(name) OR email != LOWER(TRIM(email));