syntax:functions:lower
This is an old revision of the document!
Table of Contents
Lower(text)
Category: Text function
Description
This function returns text converted to lowercase letters.
Use cases
This function can be used to perform a case-insensitive comparison of text values when the current case of the values are not known. The Upper(text) function can also be used for this.
Arguments
Argument | Type | Description |
---|---|---|
text | Text | The text value to convert to lowercase. |
Return value type: Text
Remarks
This function has no effect on numbers, symbols, or non-printing characters.
Examples
lower('Customer Service') = 'customer service' lower('IN ALL CAPS') = 'in all caps' lower([Industry]) = 'energy' //Using a field name; [Industry] = 'Energy' lower([YourIndustry]) = lower([MyIndustry]) //Case insensitive comparison between two fields
See also
syntax/functions/lower.1627888211.txt.gz · Last modified: 2021/08/02 03:10 by craigt