Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Converts a string to uppercase.
upper
Returns NULL for NULL input.
ucase(value)
| Name | Type | Required | Description |
|---|---|---|---|
| value | STRING | Yes | The string to convert. |
| Property | Value |
|---|---|
| Deterministic | Yes |
| Supports window usage | No |
| Exact result | Yes |
SELECT ucase('aBc') AS "value", ucase(CAST(NULL AS STRING)) AS null_value;
| value | null_value |
|---|---|
| ABC | NULL |
SELECT ucase('Order-abc123') AS normalized;
| normalized |
|---|
| ORDER-ABC123 |