# LOWER

> LOWER function in StackQL: convert a string to lowercase.

Source: https://stackql.io/language-spec/functions/string/lower

Returns an input string in lowercase.  

See also:  
[[` SELECT `]](/language-spec/select) [[` UPPER `]](/language-spec/functions/string/upper) [[ Data Types ]](/language-spec/data-types)

* * * 

## Syntax

```sql
SELECT LOWER(character_expression) FROM <multipartIdentifier>;
```
> The `lower()` function works for ASCII characters only.

## Arguments

__*character_expression*__  
An ASCII string.

## Return Value(s)
Returns a string value.

* * *

## Examples

### Return a string in lowercase

```sql
SELECT name, LOWER(location) FROM google.storage.buckets WHERE project = 'stackql-demo';
```

For more information, see [https://www.sqlite.org/lang_corefunc.html#lower](https://www.sqlite.org/lang_corefunc.html#lower)