locate
Returns the starting position of the first occurrence of "string_expression1" within "string_expression2". The search starts at position start "integer_expression" of "string_expression2". The first character in a string is at position 1. If "string_expression1" is not found, zero is returned.
Syntax
locate ( string_expression1, string_expression2 [ ,
integer_expression ] )Example
locate ( A, [Sales (query)].[Sales staff].[Last name] , 2 )Result
Returns the position of the character A in the last names starting at the second character of the last name.