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
Are these attributtes from an FDO connection or blocks or object data tables?
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
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.
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?
I got it to work. Here is what I typed in case anyone needs to know.
Can't find what you're looking for? Ask the community or share your knowledge.