position({search_str} IN {source_str})

Returns an integer that indicates the first occurrence of a substring in a given string. If the substring is not found, the function returns 0.

This example returns the position of the substring “der” in the City field.