Table of Contents

Upper(text)

Category: Text function


Description

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


Arguments

ArgumentTypeDescription
textTextThe text value to convert to uppercase.

Return value type: Text


Remarks

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


Examples

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)


See also