---
title: UPPER
description: Learn how to use the UPPER function to convert text strings to uppercase in calculated columns, simplify data transformation.
---
import {  Steps } from '@astrojs/starlight/components';

# 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>)
```
<Steps>
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](/studio-v8/datasources/calculated-columns-datasource/).
</Steps>