Returns the position of the first occurrence of a pattern.
Syntax
PATINDEX('%pattern%', str)Example
Enter values below to update the example in real time.
address→num_pos→customers→-- 숫자로 시작하는 주소 찾기
SELECT address, PATINDEX('%[0-9]%', address) AS num_pos
FROM customers;