topic Re: definition query in Data Management Questions

definition query

TerryWatson — Tue, 12 Jul 2016 20:17:30 GMT

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.

Re: definition query

DarrenWiens2 — Tue, 12 Jul 2016 20:22:34 GMT

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

Re: definition query

TerryWatson — Tue, 12 Jul 2016 20:30:10 GMT

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

Re: definition query

DanPatterson_Retired — Tue, 12 Jul 2016 20:30:19 GMT

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

Re: definition query

TerryWatson — Tue, 12 Jul 2016 20:38:43 GMT

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

Re: definition query

DarrenWiens2 — Wed, 13 Jul 2016 00:00:25 GMT

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