I am trying a simple query to look for accidental lower case errors. For example Pf098788 should be PF098788.
I made a simple query UPPER(UnknownCode) <> UnknownCode and I get no results. If I try UPPER(UnknownCode) = UnknownCode I get everything.
Layer us a AGOL Hosted feature service.
What am I missing here?