If a picklist has a single-quote in it, like:

   Said 'hi!'

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?

Thanks