String

RIGHT

BigQuery

Extracts a specified number of characters from the right (end) of a string. A more readable shorthand for extracting trailing characters.

Tipe hasil: STRINGDiperbarui: 13 Jun 2026

Syntax

SQL

RIGHT(value, length)

Parameter

valueSTRINGwajib

The source string

lengthINT64wajib

The number of characters to extract from the right

Contoh Penggunaan

Extract a Suffix

SQL

1 SELECT RIGHT('BigQuery', 5) as result;

Extracts the last 5 characters.

Hasil

Query

Extract File Extension

SQL

1 SELECT
2   file_name,
3   RIGHT(file_name, 3) as extension
4 FROM `project.dataset.files`
5 LIMIT 3;

Extracts the file extension (last 3 characters).

Hasil

file_name	extension
report.pdf	pdf
data.csv	csv
image.png	png

Last 4 Digits for Masking

SQL

1 SELECT
2   credit_card_number,
3   CONCAT('****-****-****-', RIGHT(credit_card_number, 4)) as masked_card
4 FROM `project.dataset.payments`
5 LIMIT 3;

Displays only the last 4 digits of a credit card number.

Hasil

credit_card_number	masked_card
1234567890123456	**--**-3456
9876543210987654	**--**-7654

Extract Code from ID

SQL

1 SELECT
2   transaction_id,
3   RIGHT(transaction_id, 6) as sequence_number
4 FROM `project.dataset.transactions`
5 WHERE RIGHT(transaction_id, 6) LIKE '0001%'
6 LIMIT 3;

Extracts the sequence number from a transaction ID.

Hasil

transaction_id	sequence_number
TRX202401000123	000123
TRX202401000124	000124

Pertanyaan Umum tentang RIGHT

Apa itu fungsi RIGHT di BigQuery?

Extracts a specified number of characters from the right (end) of a string. A more readable shorthand for extracting trailing characters. Di BigQuery, fungsi RIGHT termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan RIGHT di BigQuery?

Gunakan sintaks berikut: RIGHT(value, length). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi RIGHT?

Fungsi RIGHT mengembalikan nilai bertipe STRING. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Apa saja parameter fungsi RIGHT?

Fungsi ini memiliki 2 parameter wajib. Parameter yang digunakan: value (STRING, wajib): The source string; length (INT64, wajib): The number of characters to extract from the right.

Fungsi Terkait

SUBSTRINGSUBSTRLEFT

Ngulik Langsung

Sudah paham RIGHT? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	file_name,
3	RIGHT(file_name, 3) as extension
4	FROM `project.dataset.files`
5	LIMIT 3;

1	SELECT
2	credit_card_number,
3	CONCAT('**--**-', RIGHT(credit_card_number, 4)) as masked_card
4	FROM `project.dataset.payments`
5	LIMIT 3;

1	SELECT
2	transaction_id,
3	RIGHT(transaction_id, 6) as sequence_number
4	FROM `project.dataset.transactions`
5	WHERE RIGHT(transaction_id, 6) LIKE '0001%'
6	LIMIT 3;