---
schema_version: "1"
id: 33f171bcf7f53547c03028619349ce76279bd9c4926880b1f97073cb8626cc87
title: upper({str})
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_sql/guides/bi-sql-string-upper.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-string-upper.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ce4e1036022597f6af9af2ced538e4c28e691863b9a7829814af42dc6fa18b3b
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# upper({str})

Returns a copy of string _str_ with all cased characters converted to uppercase.

## Example

This example returns the first five entries in the City column in uppercase.

```nolang
SELECT upper(City) as upperCity FROM "Superstore"
GROUP BY City
LIMIT 5;

```

| upperCity   |
| ----------- |
| ABERDEEN    |
| ABILENE     |
| AKRON       |
| ALBUQUERQUE |
| ALEXANDRIA  |