AnsweredAssumed Answered

Using the SQL [charlist] wildcard

Question asked by Tycho on Jan 9, 2018
Latest reply on Jan 10, 2018 by Tycho

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).