I want to use SOSL to search for a Contact or Lead with a certain email. I want it to be an exact match but I am not sure about how SOSL matches the email fields with the search term. Given this SOSL query:
FIND :emailAddress IN EMAIL FIELDS RETURNING Contact(Id, Email), Lead(Id, Email)
From what I noticed, even though the search term is supposed to be an exact match, this is not always the case. For example:
jack@would match the same records
jack@emailwould match nothing even though there are records with email
email@example.com match only
How does this work?