String

CHARINDEX

Snowflake

Mencari posisi pertama substring dalam string. Equivalent dengan POSITION tapi dengan urutan parameter berbeda (SQL Server style).

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

CHARINDEX(substring, string [, start_position])

substringVARCHARwajib

String yang dicari

stringVARCHARwajib

String tempat mencari

start_positionINTEGERopsional

Posisi awal pencarian (opsional, default: 1)

SQL

1 SELECT
2   CHARINDEX('@', 'user@example.com') as at_position;

Mencari posisi karakter @.

Hasil

SQL

1 SELECT
2   text,
3   CHARINDEX('the', text) as first_pos,
4   CHARINDEX('the', text, CHARINDEX('the', text) + 1) as second_pos
5 FROM articles;

Mencari posisi pertama dan kedua dari 'the'.

Hasil

TEXT	FIRST_POS	SECOND_POS
the cat and the dog	1	13

SQL

1 SELECT
2   email,
3   LEFT(email, CHARINDEX('@', email) - 1) as username
4 FROM users;

Mengambil bagian sebelum @ dari email.

Hasil

EMAIL	USERNAME
john@example.com	john
alice@company.org	alice

STRPOS

PostgreSQL

LOCATE

MySQL

STRPOS

BigQuery

STRPOS

DuckDB

1	SELECT
2	text,
3	CHARINDEX('the', text) as first_pos,
4	CHARINDEX('the', text, CHARINDEX('the', text) + 1) as second_pos
5	FROM articles;

1	SELECT
2	email,
3	LEFT(email, CHARINDEX('@', email) - 1) as username
4	FROM users;