I noticed apps on Salesforce that could perform run CONTAINS queries. The CONTAINS filtering is possible even with the basic list filter functionality on object lists.
I tried the following with SOSL:
List<List<SObject>> searchList = [FIND '*ben* AND *berlin*' IN ALL FIELDS
RETURNING Account(Name)];
I have an account name "BigBen" in "Berlin". I am not able to find this account using upper SOSL call. I tried different combinations, but no success. How do i do SOSL calls with CONTAINS? Using the basic list filtering i am able to use CONTAINS with "ben", it gives me the expected results.