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?
I just did some testing and see what you mean. I don't think the issue is UPPER because if I do something like UPPER(field) = 'XYZ', I get 'xyz' and 'XYZ' returned. I think the issue has something to do with referencing the field on the right-hand size of the SQL statement.
Are you doing this calculation via ArcGIS Pro or in AGOL? In AGOL, the calculation for SQL is simply UPPER(<field name>).
I used the following example SQL to calculated the hosted feature layer field in Pro as well.
If using Select by attributes, I can certainly see the issue.
Best of luck,
If you Def Query a SQL server then yes. If you Def Query a GDB then no it is case sensitive. The backend of AGOL is neither i think. I could see that it may act that way though. If I try to use COLLATE Latin1_General_CS_AS it says invalid SQL.