locate

Returns the starting position of the first occurrence of "string_expression1" within "string_expression2". The search starts at position "integer_expression" of "string_expression2". The first character in a string is at position 1. If "string_expression1" is not found, then zero is returned.

Syntax

locate ( string_expression1 , string_expression2 [ ,
 integer_expression ] )