String

INITCAP

Snowflake

Mengubah huruf pertama setiap kata menjadi kapital dan sisanya lowercase. Berguna untuk formatting nama atau judul.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

INITCAP(string)

stringVARCHARwajib

String yang akan diformat ke Title Case

SQL

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

Mengubah string ke Title Case.

Hasil

Hello World

SQL

1 SELECT
2   INITCAP(first_name) as first_name,
3   INITCAP(last_name) as last_name
4 FROM customers
5 WHERE customer_id = 'CUST-001';

Menstandarkan format nama customer ke Title Case.

Hasil

FIRST_NAME	LAST_NAME
John	Smith

SQL

1 UPDATE addresses
2 SET
3   city = INITCAP(city),
4   street = INITCAP(street)
5 WHERE city = UPPER(city) OR city = LOWER(city);

Menormalisasi alamat yang ALL CAPS atau all lowercase ke Title Case.

SQL

1 SELECT
2   INITCAP('JOHN O''BRIEN') as name1,
3   INITCAP('mary-jane watson') as name2;

INITCAP mengenali apostrophe dan hyphen sebagai pemisah kata.

Hasil

NAME1	NAME2
John O'Brien	Mary-Jane Watson

1	SELECT
2	INITCAP(first_name) as first_name,
3	INITCAP(last_name) as last_name
4	FROM customers
5	WHERE customer_id = 'CUST-001';

1	UPDATE addresses
2	SET
3	city = INITCAP(city),
4	street = INITCAP(street)
5	WHERE city = UPPER(city) OR city = LOWER(city);

1	SELECT
2	INITCAP('JOHN O''BRIEN') as name1,
3	INITCAP('mary-jane watson') as name2;