Skip to content

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

ExpressionA placeholder in a function that is replaced with the actual column name.
Column NameThe 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>)
  1. Replace <expression> with VALUE([Column Name]).
  2. Replace the Column Name with the actual name of the column required.
  3. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.