---
schema_version: "1"
id: 0b06683b54bb3165507d6a1ef0f9077f2e37c041d501b18edd447cc380e4993b
title: UPPER
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/scalar-func/string-func/upper.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/upper.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 2960fb9d2632e8b73cbc5e95336444b46a0e37804224df284fe1f346cf9e5b69
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `UPPER`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Converts a string to uppercase.

## Syntax

```sql
upper(<string>)
```

## Arguments

### Required

- `<string>`: The string to convert.

## Returns

Returns a text value with all characters converted to uppercase.

## Considerations

- Non-alphabetic characters remain unchanged.
- Conversion follows locale-independent rules.

## Examples

### Convert to Uppercase

Transform a lowercase string.

```sql
SELECT upper('tom') AS result;
```

Returns `'TOM'`.

## Related Documentation

- [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/string.md)
