Differences

This shows you the differences between two versions of the page.

Link to this comparison view

expression function - lowercase [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== Lowercase (Expression Function) ======
 +
 +===== Purpose =====
 +The **Lowercase** function (LOWERCASE) changes the case of a text value to all lower-case. ​
 +
 +{{::​lowercase_initial.png?​direct&​600|}}
 +===== Parameters =====
 +The **Lowercase** function has one required parameter:
 +
 +==== Value ====
 +
 +Allowed Inputs: [[Field|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, 2019