exclude polygons from map matching the first 3 of 8 characters of a property

[Anonymous]

I've been searching in the discussion threads and the help menu but I am probably not searching the right keywords or something because I am sure this has been asked, I just cannot find it...

i have an attribute that is 8 characters long. I want to exclude from my map any polygons where the 8 digit property starts with '760' How do I do that? I tried to use a wildcard * but that didn't work. 

Thanks in advance!

Rebecca

[Murph_Map]

Are these attributtes from an FDO connection or blocks or object data tables? 

[Anonymous]

Thank you for the reply! 

They are from an FDO Connection. 

What I have is some parcels which I have queried to fit within a polyline I created. Several of the parcels have multiple polygons in one place. They did this to indicate parcel's Possessory Interest (PI; basically someone has taxable interest in the parcel but not ownership. The PI polygons have Parcel numbers that begin with 760 followed by the remaining 5 digits. I want to eliminate all of the PI parcels from my map so I am left with the just the ownership polygons. 

Rebecca

[Gary_Braun]

Right-click on your parcels layer in the Display Manager and select "Query to Filter Data...".

You need to create a query that looks similar to:

NOT (ParcelNumber LIKE '760%')

Replace ParcelNumber with whatever the correct attribute name is in your data, it should then filter your parcels and only display any that don't begin with 760.

[Anonymous]

Thank you Gary! It does not seem to like the NOT part of it. Can you tell what I am doing wrong from the screenshot?

[Gary_Braun]

Not completely sure, but you have two different criteria going on, one spatial and the second by attribute. Try add an AND before the NOT and see what happens.

[Anonymous]

I got it to work. Here is what I typed in case anyone needs to know.