index

Returns the starting number position of the substring within the full string.

Syntax

index ( <fullStr> , <subStr> )  

Parameters

Returns

Integer

Example

index ( connection : \'DB'::'TBC.tbc.MARKET'.'STATE' , "e" )