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?

[TroyNagle]

Try using two single quotes 'Johnston''s Subdivision'

[RandyBonds_Jr_]

Had a similar experience, thanks for the help!

[JacksonTrappett]

That did the trick, thanks!