String

POSITION

Snowflake

Mencari posisi pertama kemunculan substring dalam string. Mengembalikan 0 jika tidak ditemukan.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

POSITION(substring IN string) | POSITION(substring, string [, start_pos])

Parameter

substringVARCHARwajib

String yang dicari

stringVARCHARwajib

String tempat mencari

start_posINTEGERopsional

Posisi awal pencarian (opsional, default: 1)

Contoh Penggunaan

Mencari Posisi Substring

SQL

1 SELECT
2   POSITION('world' IN 'hello world') as pos1,
3   POSITION('xyz' IN 'hello world') as pos2;

Mencari posisi 'world' (ditemukan) dan 'xyz' (tidak ditemukan).

Hasil

POS1	POS2
7	0

Extract Domain dari URL

SQL

1 SELECT
2   url,
3   SUBSTRING(url, POSITION('//' IN url) + 2,
4     POSITION('/', url, POSITION('//' IN url) + 2) - POSITION('//' IN url) - 2
5   ) as domain
6 FROM websites;

Mengekstrak domain dari URL menggunakan POSITION.

Check Email Contains Domain

SQL

1 SELECT
2   email,
3   CASE WHEN POSITION('@gmail.com' IN LOWER(email)) > 0 THEN 'Gmail' ELSE 'Other' END as email_type
4 FROM users;

Mengecek apakah email adalah Gmail.

Fungsi Terkait

CHARINDEXCONTAINS

Kembali ke Snowflake Functions

1	SELECT
2	POSITION('world' IN 'hello world') as pos1,
3	POSITION('xyz' IN 'hello world') as pos2;

1	SELECT
2	url,
3	SUBSTRING(url, POSITION('//' IN url) + 2,
4	POSITION('/', url, POSITION('//' IN url) + 2) - POSITION('//' IN url) - 2
5	) as domain
6	FROM websites;

1	SELECT
2	email,
3	CASE WHEN POSITION('@gmail.com' IN LOWER(email)) > 0 THEN 'Gmail' ELSE 'Other' END as email_type
4	FROM users;