topic Re: Quick search for a certain character within an field. in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8639#M311 <HTML><HEAD></HEAD><BODY><P>select by attributes <A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/using-select-by-attributes.htm" title="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/using-select-by-attributes.htm">Using Select By Attributes—Help | ArcGIS for Desktop</A> </P><P>with the wildcard thing <A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm" title="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm">Building a query expression—Help | ArcGIS for Desktop</A> </P><P>YourField like 'A%'</P><P>but type as little as possible, select the fields, the operands, where possible and ensure there are spaces as shown</P></BODY></HTML> Thu, 19 May 2016 20:35:32 GMT DanPatterson_Retired 2016-05-19T20:35:32Z Quick search for a certain character within an field. https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8638#M310 <HTML><HEAD></HEAD><BODY><P>I have done this before, but it has been a while. I have a point shape file. I want to search for the "feature code" field that has the letter "A" in it.&nbsp; Can someone remind me how to do that? </P></BODY></HTML> Thu, 19 May 2016 18:40:32 GMT https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8638#M310 MikeHenson 2016-05-19T18:40:32Z Re: Quick search for a certain character within an field. https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8639#M311 <HTML><HEAD></HEAD><BODY><P>select by attributes <A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/using-select-by-attributes.htm" title="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/using-select-by-attributes.htm">Using Select By Attributes—Help | ArcGIS for Desktop</A> </P><P>with the wildcard thing <A href="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm" title="http://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/building-a-query-expression.htm">Building a query expression—Help | ArcGIS for Desktop</A> </P><P>YourField like 'A%'</P><P>but type as little as possible, select the fields, the operands, where possible and ensure there are spaces as shown</P></BODY></HTML> Thu, 19 May 2016 20:35:32 GMT https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8639#M311 DanPatterson_Retired 2016-05-19T20:35:32Z Re: Quick search for a certain character within an field. https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8640#M312 <HTML><HEAD></HEAD><BODY><PRE class="lia-code-sample line-numbers language-none">YourField LIKE 'A%' SUBSTRING(YourField FROM 1 FOR 1) = 'A'</PRE><P>YourField starts with (capital) A</P><PRE class="lia-code-sample line-numbers language-none">YourField LIKE '%A%'</PRE><P>YourField contains (capital) A</P><PRE class="lia-code-sample line-numbers language-none">UPPER(YourField) LIKE '%A%'</PRE><P>YourField contains 'A' or 'a'</P></BODY></HTML> Fri, 10 Dec 2021 20:21:03 GMT https://community.esri.com/t5/geoprocessing-questions/quick-search-for-a-certain-character-within-an/m-p/8640#M312 curtvprice 2021-12-10T20:21:03Z