SOQL Escape Characters

Question

I'm trying to get my Escape characters to work in Force.com explorer.

This is exactly what the data looks like in Salesforce,

Awaiting Custodian Data - Pending '8'

I need to filter in on this data with a query statement like this,

Where policy__r.Policy_Status__c = 'Awaiting Custodian Data - Pending '8''

Here is what I have tried but I cannot get to work,

'Awaiting Custodian Data - Pending \'8\''

'Awaiting Custodian Data - Pending ''8'''

'Awaiting Custodian Data - Pending \'\8\'\'

'Awaiting Custodian Data - Pending '8''

"Awaiting Custodian Data - Pending \'8\'"

I can't figure out what's not working here, anyone got an idea?

Answer 1

If you're building a string in apex, so, \' is an escape sequence so you would need to escape that do something like \\\'8\\\'