String

LENGTH

BigQuery

Mengembalikan jumlah karakter dalam string. Untuk BYTES, mengembalikan jumlah bytes.

Tipe hasil: INT64Diperbarui: 7 Jan 2026

Syntax

SQL

LENGTH(value)

Parameter

valueSTRING atau BYTESwajib

String yang akan dihitung panjangnya

Contoh Penggunaan

Panjang String Sederhana

SQL

1 SELECT LENGTH('BigQuery') as len;

Menghitung jumlah karakter.

Hasil

Validasi Panjang Input

SQL

1 SELECT
2   username,
3   LENGTH(username) as username_length,
4   CASE
5     WHEN LENGTH(username) < 3 THEN 'Too short'
6     WHEN LENGTH(username) > 20 THEN 'Too long'
7     ELSE 'Valid'
8   END as validation
9 FROM `project.dataset.users`;

Validasi panjang username.

Hasil

username	username_length	validation
jo	2	Too short
john_doe	8	Valid

Filter berdasarkan Panjang

SQL

1 SELECT *
2 FROM `project.dataset.products`
3 WHERE LENGTH(description) > 100
4   AND LENGTH(description) < 500;

Mencari produk dengan deskripsi medium length.

Fungsi Terkait

CHAR_LENGTHBYTE_LENGTH

Kembali ke BigQuery Functions

1	SELECT
2	username,
3	LENGTH(username) as username_length,
4	CASE
5	WHEN LENGTH(username) < 3 THEN 'Too short'
6	WHEN LENGTH(username) > 20 THEN 'Too long'
7	ELSE 'Valid'
8	END as validation
9	FROM `project.dataset.users`;

1	SELECT *
2	FROM `project.dataset.products`
3	WHERE LENGTH(description) > 100
4	AND LENGTH(description) < 500;