Salesforce SOSL with CONTAINS

Question

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.

Answer 1

Unlike SOQL, which uses the LIKE comparison operator to support wildcards anywhere in the search word, SOSL does not allow wildcards at the start of a search term (a "starts with" search).

In this scenario, where you're only looking for one sObject, SOQL might be a better option.

I hope this helps!

Sign up for the Salesforce training if you want to learn more about Salesforce SOSL.