topic Query tool 'contains' case sensitive? :( in ArcGIS Explorer Online Questions https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305068#M417 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>It appears the query tool, if you build a query with 'contains' against a string field, its a case sensitive query?&nbsp; Is this correct or have I missed something?&nbsp; Would be great to have the ability to control this.</SPAN><BR /><BR /><SPAN>Kind Regards,</SPAN><BR /><BR /><SPAN>Roberto</SPAN></BODY></HTML> Mon, 04 Jun 2012 11:09:11 GMT RobDunfey 2012-06-04T11:09:11Z Query tool 'contains' case sensitive? :( https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305068#M417 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>It appears the query tool, if you build a query with 'contains' against a string field, its a case sensitive query?&nbsp; Is this correct or have I missed something?&nbsp; Would be great to have the ability to control this.</SPAN><BR /><BR /><SPAN>Kind Regards,</SPAN><BR /><BR /><SPAN>Roberto</SPAN></BODY></HTML> Mon, 04 Jun 2012 11:09:11 GMT https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305068#M417 RobDunfey 2012-06-04T11:09:11Z Re: Query tool 'contains' case sensitive? :( https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305069#M418 <HTML><HEAD></HEAD><BODY><SPAN>is there an "upper" or "lower" option within the query builder (haven't used explorer online)?&nbsp; If so, cast your query to either upper or lower prior to using the contains option ... common practice in many sql style queries</SPAN></BODY></HTML> Mon, 04 Jun 2012 12:53:54 GMT https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305069#M418 DanPatterson_Retired 2012-06-04T12:53:54Z Re: Query tool 'contains' case sensitive? :( https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305070#M419 <HTML><HEAD></HEAD><BODY><SPAN>Anyone has got an answer yet? go to </SPAN><A href="https://c.na9.visual.force.com/apex/ideaView?id=08730000000boLA&amp;mc=0">https://c.na9.visual.force.com/apex/ideaView?id=08730000000boLA&amp;mc=0</A><SPAN> and vote the idea please</SPAN></BODY></HTML> Thu, 29 Aug 2013 23:12:59 GMT https://community.esri.com/t5/arcgis-explorer-online-questions/query-tool-contains-case-sensitive/m-p/305070#M419 JackZHANG 2013-08-29T23:12:59Z