I am trying to compare a Salesforce.com field with a string that contains a single quote character and I am receiving the error, ERROR at Row:1:Column:390 unexpected token: s
To handle single quotes or other reserved character in a SOQL query, we need to put a backslash in front of the character ( \ ).
The correct query to get Account Information for Joe’s boats would be the following:
select Account.Id, Account.Name, Account.Address, Account.City from Account where Account.Name = ‘Joe\’s Boats’
Link to additional Salesforce.com character’s that need to be escaped. https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_quotedstringescapes.htm