Why Does My Contacts Report Only Pull Partial Results?

We have an Oracle back-end and we are pulling a Contacts report based on Last Name, but we only see results for some of the last names in the search. Why does our report only pull partial results and how can we resolve this?

Article
Number:112976

Products:

GIFTS_GIFTS

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.