String

ENDS_WITH

BigQuery

Mengecek apakah string diakhiri dengan suffix tertentu. Return boolean.

Tipe hasil: BOOLDiperbarui: 7 Jan 2026

Syntax

SQL

ENDS_WITH(value, suffix)

valueSTRINGwajib

String yang akan dicek

suffixSTRINGwajib

Suffix yang dicari

SQL

1 SELECT ENDS_WITH('document.pdf', '.pdf') as result;

Mengecek apakah diakhiri dengan '.pdf'.

Hasil

TRUE

SQL

1 SELECT *
2 FROM `project.dataset.files`
3 WHERE ENDS_WITH(file_name, '.csv');

Filter file CSV.

SQL

1 SELECT
2   email,
3   ENDS_WITH(email, '@company.com') as is_company_email
4 FROM `project.dataset.users`;

Validasi email perusahaan.

ENDSWITH

Snowflake

1	SELECT
2	email,
3	ENDS_WITH(email, '@company.com') as is_company_email
4	FROM `project.dataset.users`;