> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

> Reference material for LOWER function

# LOWER

Converts the input string to lowercase characters. Note that Firebolt uses the `POSIX` locale, therefore `lower` only converts the ASCII characters "A" through "Z" to lowercase. Non-ASCII characters remain unchanged.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
LOWER(<expression>)
```

## Parameters

| Parameter      | Description                                         | Supported input types |
| :------------- | :-------------------------------------------------- | :-------------------- |
| `<expression>` | The string to be converted to lowercase characters. | `TEXT`                |

## Return Type

`TEXT`

## Examples

The following example converts a game player's username from uppercase to lowercase characters:

<div className="query-window">
  ```
  SELECT LOWER('ESIMPSON') AS username;
  ```

  | username <span>text</span> |
  | :------------------------- |
  | esimpson                   |

  <p><span>Rows: 1</span><span>Execution time: 7.05ms</span></p>
</div>

Because Firebolt uses the `POSIX` locale, non-ASCII characters are not lowercased:

<div className="query-window">
  ```
  SELECT LOWER('MÜNCHEN');
  ```

  | lower <span>text</span> |
  | :---------------------- |
  | mÜnchen                 |

  <p><span>Rows: 1</span><span>Execution time: 4.79ms</span></p>
</div>