ok. here it is. I have an external portal for external users to lookup their tickets (case/incident).
The view results displayed defaults to all tickets. There is a search box control.
when ABCD (which is same as ABCD*) is typed into the search box, the results contains tickets with a title/summary field that begins with ABCD
AND tickets with ABCD in the title/summary field.
In the same way, when typing some other arbitrary search value XYZ, only results that begin with the search value are returned. ( I know there are other tickets that have XYZ in the title/summary, because they show when I do a search with a prefixed wildcard *XYZ)
INCONSISTENT RESULTS!!!!
This is what drives people crazy!!! at least it drives me crazy.
If anyone can shed light on this PLEASE do so.