syntax:functions:upper
This is an old revision of the document!
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
Argument | Type | Description |
---|---|---|
text | Text | The 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') = 'HEALTH SERVICES' upper('all lowercase') = 'ALL LOWERCASE' upper([Industry]) = 'ENERGY' //Using a field name; [Industry] = 'Energy' upper([YourIndustry]) = upper([MyIndustry]) //Case insensitive comparison between two fields
See also
syntax/functions/upper.1627888601.txt.gz · Last modified: 2021/08/02 03:16 by craigt