Book Contents

Book Index

Next Topic

Home

STRPOS

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)