If you are on Oracle and you are using Contacts.Last_Name as a search filter to pull results, bear in mind that hyphens will cause the search to break.

Therefore, if you are searching as follows:

(Upper(Contacts.Last_Name)LIKE '%SMITH%' OR Upper(Contacts.Last_Name)LIKE '%GENTILE' OR Upper(Contacts.Last_Name)LIKE '%FALLON%' OR Upper(Contacts.Last_Name)LIKE '%SCHUPP-STAR%' OR Upper(Contacts.Last_Name)LIKE '%AMMIRATI%' OR Upper(Contacts.Last_Name)LIKE '%RONK%' OR Upper(Contacts.Last_Name)LIKE '%CASPER%' OR Upper(Contacts.Last_Name)LIKE '%HEALY%' OR Upper(Contacts.Last_Name)LIKE '%FURMAN%'

...your search will omit results for Schupp-Star, Ammirati, Ronk, Casper, Healy and Furman as the hyphen will break the search.

The suggested means past this is to remove the hyphen and choose either one two names in the hyphenated last name.

If the search were written as below:

(Upper(Contacts.Last_Name)LIKE '%SMITH%' OR Upper(Contacts.Last_Name)LIKE '%GENTILE' OR Upper(Contacts.Last_Name)LIKE '%FALLON%' OR Upper(Contacts.Last_Name)LIKE '%STAR%' OR Upper(Contacts.Last_Name)LIKE '%AMMIRATI%' OR Upper(Contacts.Last_Name)LIKE '%RONK%'

...the search would pull results more effectively.