UPPER
The UPPER function converts all letters in a text string to uppercase.
Applicable to
Calculated Columns
Return Value
- The UPPER function returns a new text string where all lowercase letters in the input text are converted to uppercase. Characters that are not letters remain unchanged.
- If the input is NULL or BLANK, the function returns NULL.
Remark
- The UPPER function is case-insensitive, meaning that it does not change the case of characters that are already lowercase.
- UPPER function is applicable only for text values.
Syntax
UPPER(<expression>)
LOWER in Calculated Columns
Expression | A placeholder in a function that is replaced with the actual column name. |
---|---|
Column Name | The name of the column in the dataset or Datasource that contains the values you want to analyze. |
Write the UPPER function. For instance
UPPER(<expression>)
- Replace
<expression>
withVALUE([Column Name]).
- Replace the Column Name with the actual name of the column required.
- To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.