1 of 1 people found this helpful
Use this criteria: *smith* to find all records where the text smith is located somewhere within the specified field.
The special characters are being used to define "words." "Joe_Smith_Williams" is three words, "JoeSmithWilliams" is one word.
Searching for "Joe" will do an ignoring-case search for words that begin with Joe. It will find "Joe_Smith_Williams" and "Billy_Joel".
The help documentation has a good description of the different search criteria.