upper(...)Returns the uppercase equivalent of a string of text
Works with the following datatypes:
This function works with 2.1 endpoint(s). What does this mean? »
The upper(...) function is used within the $select or $where parameters to upper-case a Text value. For example, you could use it within the $select statement to upper-case names from the Chicago salaries dataset:
https://data.cityofchicago.org/resource/tt4n-kn4t.json?$select=upper(name), annual_salary
You can also use it within the $where parameter to do case-insensitive matches:
https://data.cityofchicago.org/resource/tt4n-kn4t.json?$where=upper(name)=upper('ABARCA, ANABEL')