<< Click to Display Table of Contents >> Navigation:  Apollo SQL > String Functions > Pos

Searches for a substring within a string.

Syntax:

Pos( SubStr: String, Col_Name: String ): Integer

 

SubStr and Col_Name are string-type expressions. Pos searches for SubStr within S and returns an integer value that is the index of the first character of Substr within S. Pos ignores case-insensitive matches. If SubStr is not found, Pos returns zero.

 

Example:

SELECT * FROM test WHERE Pos( 'abc', LAST ) > 0