Using an apostrophe in a Query

Discussion created by jtrappet2010 on Sep 26, 2011
Latest reply on Oct 3, 2011 by jtrappet2010
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?