Uppercase (Expression Function)


The Uppercase function (UPPERCASE) converts all of the characters in the value to upper case.


The Uppercase function has one required parameter:


Allowed Inputs: field value or text string

Either use the use the Query Builder to choose a field that contains the string or use type a value to enter a text string. While it is technically possible to use a text string with this function it is not recommended.


The output of the Uppercase function is a string with all of the characters converted to uppercase. For example UPPERCASE(“The Quick Brown Fox”) would result in “THE QUICK BROWN FOX”.


The output of the Uppercase function is commonly used to take user input and make sure it is more uniform by making sure all the characters are in the same case. For example UPPERCASE(“Y”) and UPPERCASE(“y”) both result in “Y”.

expression function - uppercase.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024