String
BigQuery
CONCAT
BigQueryConcatenates two or more strings into one. A foundational string concatenation function in BigQuery that supports multiple data types.
Tipe hasil:
STRINGDiperbarui: 13 Jun 2026Syntax
SQL
CONCAT(value1, value2 [, ...])Parameter
value1, value2, ...STRING or other typeswajib
The values to concatenate. Non-string values are cast to STRING
Contoh Penggunaan
Simple Concatenation
SQL
1 SELECT CONCAT('Hello', ' ', 'World') as greeting;
Joins three strings into one.
Hasil
Hello World
Concatenate Columns
SQL
1 SELECT 2 CONCAT(first_name, ' ', last_name) as full_name 3 FROM `project.dataset.employees` 4 LIMIT 3;
Builds a full name from first and last name columns.
Hasil
| full_name |
|---|
| John Doe |
| Jane Smith |
| Bob Wilson |
Concatenate Mixed Types
SQL
1 SELECT 2 CONCAT('Order #', CAST(order_id AS STRING), ' - Total: $', FORMAT('%,.2f', amount)) as order_summary 3 FROM `project.dataset.orders` 4 LIMIT 3;
Concatenates a string with a formatted number.
Hasil
| order_summary |
|---|
| Order #1001 - Total: $1,500.00 |
| Order #1002 - Total: $2,350.00 |
Handle NULL with IFNULL
SQL
1 SELECT 2 CONCAT( 3 first_name, ' ', 4 IFNULL(middle_name, ''), 5 IF(middle_name IS NOT NULL, ' ', ''), 6 last_name 7 ) as full_name 8 FROM `project.dataset.customers`;
Concatenates a name with an optional middle name.
Hasil
| full_name |
|---|
| John William Doe |
| Jane Smith |
Pertanyaan Umum tentang CONCAT
Apa itu fungsi CONCAT di BigQuery?
Concatenates two or more strings into one. A foundational string concatenation function in BigQuery that supports multiple data types. Di BigQuery, fungsi CONCAT termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.
Bagaimana cara menggunakan CONCAT di BigQuery?
Gunakan sintaks berikut: CONCAT(value1, value2 [, ...]). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.
Apa nilai yang dikembalikan oleh fungsi CONCAT?
Fungsi CONCAT 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 CONCAT?
Fungsi ini memiliki 1 parameter wajib. Parameter yang digunakan: value1, value2, ... (STRING or other types, wajib): The values to concatenate. Non-string values are cast to STRING.
Fungsi Terkait
Ngulik Langsung
Latihan Langsung →Sudah paham CONCAT? Latih langsung di browser
Latihan interaktif, langsung di browser.