UPPER
Functions › Text › Case and length
Returns a string with every letter in upper case.
Syntax
UPPER( <string> )
Arguments
| Argument | Description |
|---|---|
<string> | The text to convert. A number, boolean or date is converted as its text. |
Returns
Text. NULL when <string> is NULL.
Usage notes
- Letters outside ASCII are converted too, one character at a time:
UPPER('école')isÉCOLE. - On large tables the engine runs it in the data store, in the select list and in
WHERE.
Examples
SELECT p.key, UPPER(p.sku) AS sku
FROM Product p
WHERE UPPER(p.sku) = 'AB-100'
| key | sku |
|---|---|
| P-7 | AB-100 |
SELECT DISTINCT UPPER(TRIM(a.country)) AS country
FROM tables.crm.account a
ORDER BY country
| country |
|---|
| AU |
| NZ |
| US |