topic Using an apostrophe in a Query in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19451#M93 <HTML><HEAD></HEAD><BODY><SPAN>In the query feature endpoint, I need to be able to search for records which contain an apostrophe in the data, for example:</SPAN><BR /><PRE class="plain" name="code">Johnston's Subdivision</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>If I submit a query like this:</SPAN><BR /><PRE class="plain" name="code">SUBDIVISION like '%johnston's%'</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>The apostrophe in the middle ends up causing an error.&nbsp; I have tried escaping it these two ways but neither worked:</SPAN><BR /><PRE class="plain" name="code">\' &amp;apos;</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>I also tried submitting double quotes like this:</SPAN><BR /><PRE class="plain" name="code">SUBDIVISION like "%johnston's%"</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>No luck with that either.&nbsp; Does anyone know what the correct way to do this is?</SPAN></BODY></HTML> Mon, 26 Sep 2011 14:08:26 GMT JacksonTrappett 2011-09-26T14:08:26Z Using an apostrophe in a Query https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19451#M93 <HTML><HEAD></HEAD><BODY><SPAN>In the query feature endpoint, I need to be able to search for records which contain an apostrophe in the data, for example:</SPAN><BR /><PRE class="plain" name="code">Johnston's Subdivision</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>If I submit a query like this:</SPAN><BR /><PRE class="plain" name="code">SUBDIVISION like '%johnston's%'</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>The apostrophe in the middle ends up causing an error.&nbsp; I have tried escaping it these two ways but neither worked:</SPAN><BR /><PRE class="plain" name="code">\' &amp;apos;</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>I also tried submitting double quotes like this:</SPAN><BR /><PRE class="plain" name="code">SUBDIVISION like "%johnston's%"</PRE><DIV style="display:none;"> </DIV><BR /><SPAN>No luck with that either.&nbsp; Does anyone know what the correct way to do this is?</SPAN></BODY></HTML> Mon, 26 Sep 2011 14:08:26 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19451#M93 JacksonTrappett 2011-09-26T14:08:26Z Re: Using an apostrophe in a Query https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19452#M94 <HTML><HEAD></HEAD><BODY><SPAN>Try using two single quotes 'Johnston''s Subdivision'</SPAN></BODY></HTML> Wed, 28 Sep 2011 18:52:18 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19452#M94 TroyNagle 2011-09-28T18:52:18Z Re: Using an apostrophe in a Query https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19453#M95 <HTML><HEAD></HEAD><BODY><SPAN>That did the trick, thanks!</SPAN></BODY></HTML> Mon, 03 Oct 2011 15:25:18 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/19453#M95 JacksonTrappett 2011-10-03T15:25:18Z Re: Using an apostrophe in a Query https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/1396836#M4701 <P>Had a similar experience, thanks for the help!</P> Fri, 15 Mar 2024 21:17:48 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/using-an-apostrophe-in-a-query/m-p/1396836#M4701 RandyBonds_Jr_ 2024-03-15T21:17:48Z