MSSQL›String Functions›CHARINDEX
←REPLACE

CHARINDEXString Functions

PATINDEX→

Returns the position of a substring.

Syntax

CHARINDEX(substr, str [, start])

Example

Enter values below to update the example in real time.

email→
at_pos→
users→
-- '@' 위치 찾기
SELECT email, CHARINDEX('@', email) AS at_pos
FROM users;