If a picklist has a single-quote in it, like:
It appears we should create SOQL to query this like:
select FirstName, Email from Contact where LeadSource = 'Said \'hi!\''
This executes without error, but generates zero rows, even though I set the LeadSource for a contact to have this value. Is this a Salesforce bug, or should the SOQL be formatted differently?