I'm trying to select by attributes on a parcel shapefile with 555k+ records using the apn field and the statement is returning records that have completely different values. My initial statement was
"apn" = '525-670-10-2'
And received the top two records with APNs starting with 84A.
Then I tried a wild card and got a whole slew of records starting with 84A:
Has anyone encountered this and was able to correct it? I'm using ArcMap 10.6