I am trying to make a
SOQL query trying to match email ids with lower case:
SELECT Id, Custom_Email_Id from Custom_Object where Custom_Email_Id IN :list_of_email_ids
Here, I am trying to get all objects with its lower cased
list_of_email_ids. I have tried searching in documentation but couldn't find an
SOQL function to lower case string.
If this is not possible, is there any other way this could be done?