topic I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder? in User Conference Questions https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670266#M990 <HTML><HEAD></HEAD><BODY><P>I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder?</P></BODY></HTML> Tue, 04 Nov 2014 10:25:35 GMT JessicaPark 2014-11-04T10:25:35Z I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder? https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670266#M990 <HTML><HEAD></HEAD><BODY><P>I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder?</P></BODY></HTML> Tue, 04 Nov 2014 10:25:35 GMT https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670266#M990 JessicaPark 2014-11-04T10:25:35Z Re: I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder? https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670267#M991 <HTML><HEAD></HEAD><BODY><P>Like enables you to use wildcards, the wildcard depends upon the type of table you are querying&nbsp; see the help topic on <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#/Building_a_query_expression/00s50000002t000000/">queries within Arcmap</A>&nbsp;&nbsp;&nbsp;&nbsp; there is an example there STATE_NAME LIKE 'Miss%' which will find all cases beginning with Miss within a field&nbsp; </P><P></P><P>The <A href="http://resources.arcgis.com/en/help/main/10.2/index.html#/SQL_reference_for_query_expressions_used_in_ArcGIS/00s500000033000000/">SQL reference</A> is in this link as well.</P></BODY></HTML> Tue, 04 Nov 2014 10:52:35 GMT https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670267#M991 DanPatterson_Retired 2014-11-04T10:52:35Z Re: I'm using Query Builder, and there are four options which are LIKE, AND, OR, NOT. I understand what the latter four options are for but i don't know what LIKE is for. Can anybody explain me what LIKE is for in Query Builder? https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670268#M992 <HTML><HEAD></HEAD><BODY><P>LIKE is also usually case insensitive.</P><P></P><P>Of course SQL syntax varies somewhat among data formats and DBMS's. Dan's link has some of those details.</P><P></P><P>I suggest moving this thread to <A href="https://community.esri.com/space/2046">GIS</A>‌</P></BODY></HTML> Thu, 06 Nov 2014 06:49:43 GMT https://community.esri.com/t5/user-conference-questions/i-m-using-query-builder-and-there-are-four-options/m-p/670268#M992 curtvprice 2014-11-06T06:49:43Z