INDEXOF
The function will return the position of the first character of the first string that matches the string specified in the second argument.
INDEXOF( <field_name or string> , <field_name or string> , [START] )
-
field name or string: The field or string to be searched.
-
field name or string: The field or string to find
-
START: The character position to begin the search at.
Example: create a field on the CUSTOMER table that gives the character position of the first "a" on or after the third character.
INDEXOF( [CUSTOMER.SURNAME] , "a" , 3 )