I'm (attempting to) use the select by attributes function in a 10.5.1 MXD. I tried both a file GeoDatabase and our Enterprise database The select by list statement does not seem to work. When I put in this –
Taxlot.MapTaxlot LIKE '%[RWT]%'
it does not return any records. I pulled the % off the end as some of the strings end with those letters, and tried using parentheses instead of square brackets. I also tried
Taxlot.MapTaxlot IN ('%R%', '%W%', '%T%') - which selects nothing and
Taxlot.MapTaxlot NOT IN ('%R%', '%W%', '%T%') - which selects everything
The list wildcard seems to be pretty standard in SQL, but I didn't see anything about it in the ESRI documentation (not that that would be the first time I missed something).