String

INITCAP

BigQuery

Mengubah huruf pertama setiap kata menjadi kapital dan sisanya menjadi kecil. Title case transformation.

Tipe hasil: STRINGDiperbarui: 7 Jan 2026

Syntax

SQL

INITCAP(value)

valueSTRINGwajib

String yang akan diubah ke title case

SQL

1 SELECT INITCAP('hello world') as result;

Mengubah ke title case.

Hasil

Hello World

SQL

1 SELECT
2   INITCAP(LOWER(full_name)) as formatted_name
3 FROM `project.dataset.customers`;

Standardisasi format nama customer.

Hasil

formatted_name
John Doe
Jane Smith

SQL

1 SELECT
2   INITCAP(LOWER(street_address)) as formatted_address
3 FROM `project.dataset.addresses`;

Format alamat dengan proper capitalization.

Hasil

formatted_address
Jalan Sudirman No 123
Ruko Central Park Blok A

1	SELECT
2	INITCAP(LOWER(full_name)) as formatted_name
3	FROM `project.dataset.customers`;

1	SELECT
2	INITCAP(LOWER(street_address)) as formatted_address
3	FROM `project.dataset.addresses`;