Lowercase (Expression Function)

Purpose

The Lowercase function (LOWERCASE) changes the case of a text value to all lower-case.

Parameters

The Lowercase 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 Lowercase function is a string with all the values converted to lowercase. For example LOWERCASE(“The Quick Brown Fox”) would result in “the quick brown fox”.

Example

The output of the Lowercase 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 LOWERCASE(“Y”) and LOWERCASE(“y”) both result in “y”.

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