Uppercase (Expression Function)

Purpose

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

Parameters

The Uppercase function has one required parameter:

Value

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.

Output

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”.

Example

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