String

LEFT

BigQuery

Mengambil sejumlah karakter dari sisi kiri (awal) string. Shorthand yang lebih mudah dibaca dibanding SUBSTR untuk mengambil karakter awal.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

LEFT(value, length)

Parameter

valueSTRINGwajib

String sumber

lengthINT64wajib

Jumlah karakter yang diambil dari kiri

Contoh Penggunaan

Mengambil Prefix

SQL

1 SELECT LEFT('BigQuery', 3) as result;

Mengambil 3 karakter pertama.

Hasil

Big

Kode Negara dari Phone Number

SQL

1 SELECT
2   phone_number,
3   LEFT(phone_number, 3) as country_code
4 FROM `project.dataset.contacts`
5 WHERE phone_number LIKE '+62%'
6 LIMIT 3;

Mengekstrak kode negara dari nomor telepon.

Hasil

phone_number	country_code
+6281234567890	+62
+6287654321098	+62

Masking Data Sensitif

SQL

1 SELECT
2   email,
3   CONCAT(LEFT(email, 3), '***@', SPLIT(email, '@')[OFFSET(1)]) as masked_email
4 FROM `project.dataset.users`
5 LIMIT 3;

Menyembunyikan sebagian email untuk privasi.

Hasil

email	masked_email
john.doe@gmail.com	joh***@gmail.com
jane@company.com	jan***@company.com

Kategorisasi berdasarkan Prefix

SQL

1 SELECT
2   LEFT(sku, 2) as category,
3   COUNT(*) as product_count
4 FROM `project.dataset.products`
5 GROUP BY category
6 ORDER BY product_count DESC;

Mengelompokkan produk berdasarkan prefix SKU.

Hasil

category	product_count
EL	450
FA	320
FO	280

Fungsi Terkait

SUBSTRINGSUBSTRRIGHT

Kembali ke BigQuery Functions

1	SELECT
2	phone_number,
3	LEFT(phone_number, 3) as country_code
4	FROM `project.dataset.contacts`
5	WHERE phone_number LIKE '+62%'
6	LIMIT 3;

1	SELECT
2	email,
3	CONCAT(LEFT(email, 3), '***@', SPLIT(email, '@')[OFFSET(1)]) as masked_email
4	FROM `project.dataset.users`
5	LIMIT 3;

1	SELECT
2	LEFT(sku, 2) as category,
3	COUNT(*) as product_count
4	FROM `project.dataset.products`
5	GROUP BY category
6	ORDER BY product_count DESC;