String

ENDSWITH

Snowflake

Mengecek apakah string diakhiri dengan suffix tertentu. Mengembalikan TRUE jika cocok.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

ENDSWITH(string, suffix)

Parameter

stringVARCHARwajib

String yang akan dicek

suffixVARCHARwajib

Suffix yang dicari di akhir string

Contoh Penggunaan

Check File Extension

SQL

1 SELECT
2   filename,
3   ENDSWITH(filename, '.pdf') as is_pdf,
4   ENDSWITH(filename, '.csv') as is_csv
5 FROM files;

Mengecek tipe file berdasarkan extension.

Hasil

FILENAME	IS_PDF	IS_CSV
report.pdf	TRUE	FALSE
data.csv	FALSE	TRUE
image.png	FALSE	FALSE

Filter Email Domain

SQL

1 SELECT *
2 FROM users
3 WHERE ENDSWITH(email, '@company.com');

Mencari user dengan email domain company.com.

Check Phone Country Code

SQL

1 SELECT
2   phone_number,
3   CASE
4     WHEN ENDSWITH(country_code, '62') THEN 'Indonesia'
5     WHEN ENDSWITH(country_code, '1') THEN 'USA'
6     ELSE 'Other'
7   END as country
8 FROM contacts;

Mengidentifikasi negara berdasarkan akhir kode negara.

Fungsi Equivalen di Database Lain

ENDS_WITH

BigQuery

Fungsi Terkait

STARTSWITH

Kembali ke Snowflake Functions

1	SELECT
2	filename,
3	ENDSWITH(filename, '.pdf') as is_pdf,
4	ENDSWITH(filename, '.csv') as is_csv
5	FROM files;

1	SELECT
2	phone_number,
3	CASE
4	WHEN ENDSWITH(country_code, '62') THEN 'Indonesia'
5	WHEN ENDSWITH(country_code, '1') THEN 'USA'
6	ELSE 'Other'
7	END as country
8	FROM contacts;