String

STARTSWITH

Snowflake

Mengecek apakah string dimulai dengan prefix tertentu. Mengembalikan TRUE jika cocok.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

STARTSWITH(string, prefix)

Parameter

stringVARCHARwajib

String yang akan dicek

prefixVARCHARwajib

Prefix yang dicari di awal string

Contoh Penggunaan

Check URL Protocol

SQL

1 SELECT
2   url,
3   STARTSWITH(url, 'https://') as is_secure
4 FROM websites;

Mengecek apakah URL menggunakan HTTPS.

Hasil

URL	IS_SECURE
https://example.com	TRUE
http://insecure.com	FALSE

Filter by ID Prefix

SQL

1 SELECT *
2 FROM transactions
3 WHERE STARTSWITH(transaction_id, 'TXN-2024');

Mencari transaksi dengan ID dimulai 'TXN-2024'.

Categorize by Product Code

SQL

1 SELECT
2   product_code,
3   CASE
4     WHEN STARTSWITH(product_code, 'EL-') THEN 'Electronics'
5     WHEN STARTSWITH(product_code, 'CL-') THEN 'Clothing'
6     WHEN STARTSWITH(product_code, 'FD-') THEN 'Food'
7     ELSE 'Other'
8   END as category
9 FROM products;

Mengkategorikan produk berdasarkan prefix kode.

Fungsi Equivalen di Database Lain

STARTS_WITH

PostgreSQL

STARTS_WITH

BigQuery

Fungsi Terkait

ENDSWITH

Kembali ke Snowflake Functions

1	SELECT
2	url,
3	STARTSWITH(url, 'https://') as is_secure
4	FROM websites;

1	SELECT *
2	FROM transactions
3	WHERE STARTSWITH(transaction_id, 'TXN-2024');

1	SELECT
2	product_code,
3	CASE
4	WHEN STARTSWITH(product_code, 'EL-') THEN 'Electronics'
5	WHEN STARTSWITH(product_code, 'CL-') THEN 'Clothing'
6	WHEN STARTSWITH(product_code, 'FD-') THEN 'Food'
7	ELSE 'Other'
8	END as category
9	FROM products;