Category: Text function

This function returns text converted to lowercase letters.

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.

Return value type: Text

This function has no effect on numbers, symbols, or non-printing characters.

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)

• Proper(text)
• Upper(text)