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.

String

CONCAT

BigQuery

Concatenates two or more strings into one. A foundational string concatenation function in BigQuery that supports multiple data types.

Tipe hasil: STRINGDiperbarui: 13 Jun 2026

Syntax

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.

Fungsi Terkait

STRING_AGG

Ngulik Langsung

Sudah paham CONCAT? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	CONCAT(first_name, ' ', last_name) as full_name
3	FROM `project.dataset.employees`
4	LIMIT 3;

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;

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`;