I am currently trying to implement a sosl search query, so I can filter out non-letter characters for searching inside the salesforce database. Everything works as expected, however when I encounter a space character in the inputted data, I replace it with a wildcard for searching e.g.
FIND {"Ab" AND "cd*ef"} IN ALL FIELDS RETURNING Candidate__c(Firstname__c, Lastname__c)
I would expect to get the following candidate;
Firstname__c: Ab
Lastname__c: cd ef
However I am not receiving any result from my searchquery. With following query, the correct candidate is returned;
FIND {"Ab" AND "cd ef"} IN ALL FIELDS RETURNING Candidate__c(Firstname__c, Lastname__c)
Is this expected behaviour for the wildcards in a SOSL query and are there any workarounds? Thanks.