# lower

[Read this page in HTML](https://www.scopedb.io/docs/reference/functions/string/lower)

Converts a string to lowercase.

## Syntax

```scopeql
lower(<string>)
```

## Arguments

| Argument   | Type     | Description          |
| ---------- | -------- | -------------------- |
| `<string>` | `string` | String to transform. |

## Returns

Returns `string`. Returns NULL if the input is NULL.

## Examples

Normalize channel capitalization before counting checkout events.

```scopeql
VALUES ('Web'), ('WEB'), ('web'), ('Mobile'), ('mobile')
SELECT lower($0) AS channel
GROUP BY channel
AGGREGATE count() AS events
ORDER BY channel
```

```text
+---------+--------+
| channel | events |
+---------+--------+
| mobile  | 2      |
| web     | 3      |
+---------+--------+
```