---
schema_version: "1"
id: c77dc77af78ea2f8b0334928c40142d22d2700c390a686ad156c42288f4e4ef7
title: LOWER
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/lower.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/lower.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 91fc28a98955a1a92d6f0822e3e1cb076a3ff9ef0cbd0aee6c7ec04c63272c32
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `LOWER`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Converts a string to lowercase.

## Syntax

```sql
lower(<string>)
```

## Arguments

### Required

- `<string>`: The string to convert.

## Returns

Returns a text value with all characters converted to lowercase.

## Considerations

- Non-alphabetic characters remain unchanged.

## Examples

### Convert to Lowercase

Transform an uppercase string.

```sql
SELECT lower('TOM') AS result;
```

Returns `'tom'`.

## Related Documentation

- [String Types](https://developer.salesforce.com/docs/data/data-cloud-query-guide/datatype/string.md)