String

LENGTH

Snowflake

Mengembalikan jumlah karakter dalam sebuah string. LEN adalah alias yang identik.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

LENGTH(string) | LEN(string)

Parameter

stringVARCHARwajib

String yang akan dihitung panjangnya

Contoh Penggunaan

Menghitung Panjang String

SQL

1 SELECT LENGTH('Snowflake') as len;

Menghitung jumlah karakter dalam string.

Hasil

Validasi Panjang Data

SQL

1 SELECT
2   username,
3   LENGTH(username) as username_length
4 FROM users
5 WHERE LENGTH(username) < 3 OR LENGTH(username) > 20;

Mencari username dengan panjang tidak valid (< 3 atau > 20 karakter).

Hasil

USERNAME	USERNAME_LENGTH
ab	2
verylongusername12345	21

Analisis Panjang Deskripsi

SQL

1 SELECT
2   category,
3   AVG(LENGTH(description)) as avg_desc_length,
4   MAX(LENGTH(description)) as max_desc_length,
5   MIN(LENGTH(description)) as min_desc_length
6 FROM products
7 GROUP BY category;

Menganalisis panjang deskripsi produk per kategori.

Hasil

CATEGORY	AVG_DESC_LENGTH	MAX_DESC_LENGTH	MIN_DESC_LENGTH
Electronics	250	500	50
Clothing	150	300	30

Fungsi Terkait

LEN

Kembali ke Snowflake Functions

1	SELECT
2	username,
3	LENGTH(username) as username_length
4	FROM users
5	WHERE LENGTH(username) < 3 OR LENGTH(username) > 20;

1	SELECT
2	category,
3	AVG(LENGTH(description)) as avg_desc_length,
4	MAX(LENGTH(description)) as max_desc_length,
5	MIN(LENGTH(description)) as min_desc_length
6	FROM products
7	GROUP BY category;