Upper(text)

Category: Text function

This function returns text converted to uppercase 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 Lower(text) function can also be used for this.

Return value type: Text

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

upper('Health Services') //Returns 'HEALTH SERVICES'

upper('all lowercase') //Returns 'ALL LOWERCASE'

upper([Industry]) //Returns 'ENERGY'  (Using a field name; [Industry] = 'Energy')

upper([YourIndustry]) = upper([MyIndustry])  (Case insensitive comparison between two fields)

• Lower(text)
• Proper(text)