STRPOS returns an INTEGER values representing the location of a specified substring with a string (counting from one).
Syntax
STRPOS ( string , substring )
Semantics
string |
(CHAR or VARCHAR) is the string in which to locate the substring |
substring |
(CHAR or VARCHAR) is the substring to locate |
Notes
Examples
=> SELECT STRPOS('1234','3');
strpos
--------
3
(1 row)