User Tools

Site Tools


syntax:functions:lower

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

ArgumentTypeDescription
textTextThe 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') //Returns 'customer service'
lower('IN ALL CAPS') //Returns 'in all caps'
lower([Industry]) //Returns 'energy'  (Using a field name; [Industry] = 'Energy')
lower([YourIndustry]) = lower([MyIndustry])  (Case insensitive comparison between two fields)


See also

syntax/functions/lower.txt · Last modified: 2021/08/14 22:18 by craigt