Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

upper(...)

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')