---
schema_version: "1"
id: 065cc47bbf5cef7cf59af50ec3b19112a2a4ab1bbaa1dccf1e49185f9ebd6190
title: lower({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-lower.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-sql/guide/bi-sql-string-lower.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 81ac3dd29ab8885b3e3b5cd365f744bdacc0d7bf142e0da26fe90e9d37781b61
products:
  - SQL for Analytics Developer Guide
  - analytics
---

# lower({str})

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

## Example

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

```nolang
SELECT lower(City) as "lCity"
FROM "Superstore"
GROUP BY City
LIMIT 5;

```

| lCity       |
| ----------- |
| aberdeen    |
| abilene     |
| akron       |
| albuquerque |
| alexandria  |