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. Can someone remind me how to do that?
select by attributes Using Select By Attributes—Help | ArcGIS for Desktop
with the wildcard thing Building a query expression—Help | ArcGIS for Desktop
YourField like 'A%'
but type as little as possible, select the fields, the operands, where possible and ensure there are spaces as shown
YourField LIKE 'A%'
SUBSTRING(YourField FROM 1 FOR 1) = 'A'
YourField starts with (capital) A
YourField LIKE '%A%'
YourField contains (capital) A
UPPER(YourField) LIKE '%A%'
YourField contains 'A' or 'a'
Retrieving data ...