Hi Doug,
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.
UPPER(NOTES)
If using Select by attributes, I can certainly see the issue.
Best of luck,
Marisa