definition query

[TerryWatson]

I'm wondering what definition query to use to not display features in a field. For example, field is "Name", data is PETROLEUM WELL NO 1 TH and I do not want features with TH in them displayed.

[DarrenWiens2 · Accepted solution]

Ignores 'TH' anywhere': "Name" Not Like '%TH%'

Ignores 'TH' only at the end: "Name" Not Like '%TH'

Ignores 'TH' preceded by a space: "Name" Not Like '% TH%'

etc.

Building a query expression—Help | ArcGIS for Desktop

[TerryWatson]

excellent, thank you very much...have a great day!

[DanPatterson_Retired]

Building a query expression—Help | ArcGIS for Desktop

NOT  YourField LIKE '%TH'

with the appropriate field designators depending on the source table (and I am not sure if NOT has to be outside the field or you can use NOT LIKE... not near Arc* now) But the key is to use a wildcard and TH the example shown is if the field always ends in TH use %TH otherwise %TH% but that will find a whole bunch of others I suspect. So once you have selected those, then NOT switches the selection leaving those behind

EDIT Too slow... never get a coffee mid answer

[TerryWatson]

in my case the TH can appear anywhere, and the data is different lengths...looks like I have success with    "Name" NOT LIKE '% TH %'

[DarrenWiens2]

Of course, that definition query ('% TH %') will not match your original example ('PETROLEUM WELL NO 1 TH'), which does not end in a space.