upper
On this page
Converts a string to uppercase.
Syntax
upper(<string>)Arguments
| Argument | Type | Description |
|---|---|---|
<string> | string | String to transform. |
Returns
Returns string. Returns NULL if the input is NULL.
Examples
Put region codes from different event producers into one representation before grouping.
VALUES ('us'), ('US'), ('gb'), ('Gb')
SELECT upper($0) AS region
GROUP BY region
AGGREGATE count() AS events
ORDER BY region+--------+--------+
| region | events |
+--------+--------+
| GB | 2 |
| US | 2 |
+--------+--------+