String

LEN

Snowflake

Mengembalikan panjang string dalam jumlah karakter. LEN adalah alias untuk LENGTH di Snowflake.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

LEN(string) | LENGTH(string)

Parameter

stringVARCHARwajib

String yang akan dihitung panjangnya

Contoh Penggunaan

Panjang String Sederhana

SQL

1 SELECT
2   LEN('Hello') as len1,
3   LEN('Hello World') as len2,
4   LEN('') as len_empty;

Menghitung panjang berbagai string.

Hasil

LEN1	LEN2	LEN_EMPTY
5	11	0

Validasi Panjang Data

SQL

1 SELECT
2   phone_number,
3   LEN(phone_number) as length
4 FROM customers
5 WHERE LEN(phone_number) != 12;

Mencari nomor telepon yang tidak sesuai format (panjang bukan 12 digit).

Analisis Panjang Deskripsi

SQL

1 SELECT
2   category,
3   AVG(LEN(description)) as avg_desc_length,
4   MAX(LEN(description)) as max_desc_length,
5   MIN(LEN(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	180	350	30

Fungsi Terkait

LENGTHARRAY_SIZE

Kembali ke Snowflake Functions

1	SELECT
2	LEN('Hello') as len1,
3	LEN('Hello World') as len2,
4	LEN('') as len_empty;

1	SELECT
2	phone_number,
3	LEN(phone_number) as length
4	FROM customers
5	WHERE LEN(phone_number) != 12;

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