Overriding the predefined search style

To override the default search style for a character field, enter exactly what you are searching for in the field, and include a relational operator or wildcard character. For example, you can use an equal sign (=) to search for an exact match even if the field has a search style of Anywhere. Thus, if you enter =Bob Jones in the Created By field of a form, the search will find all the requests created by Bob Jones. The search will not find requests created by Bob Joneson.

You can also use the advanced search bar to override a field's search style. For example, to override the Created By field in the previous example with a Leading search, you would specify the following criteria in the advanced search bar:
'Created By' LIKE "Bob Jones%"