Using an apostrophe in a Query

JacksonTrappett

In the query feature endpoint, I need to be able to search for records which contain an apostrophe in the data, for example:

Johnston's Subdivision

If I submit a query like this:

SUBDIVISION like '%johnston's%'

The apostrophe in the middle ends up causing an error.  I have tried escaping it these two ways but neither worked:

\'

'

I also tried submitting double quotes like this:

SUBDIVISION like "%johnston's%"

No luck with that either.  Does anyone know what the correct way to do this is?

RandyBonds_Jr_

Had a similar experience, thanks for the help!