I have a vector layer containing all of the property parcels in the county. There is a field called "PROP_TYPE" that contains the type of property. I am trying to select all of the residential properties, which are coded as "RES" in the PROP_TYPE field.
I tried to do this by clearing current selection, making sure the parcels layer was the active layer, and then going to the "Select features by expression" dialog, and typed in the following queries:
"PROP_TYPE" IS "RES"
"PROP_TYPE" LIKE "%RES%"
The first returns only 533 features, but there are approximately 75,000 of them that should be selected. I can count them when sorted by prop_type in the attributes table, and see that they all contain exactly the same text in this field ("RES") ... so I can't figure out why some are matching and others aren't. Also, I don't understand why the first result would return 533 while the second would return 0. I would think the 2nd one would always have at least as many as the first, if not more, since the pattern includes more possible matches.
Can someone explain to me what is going on?