UPPER
All functions > STRING > UPPER
Returns the string with all characters converted to uppercase.
Signatures
Returns: String with all characters converted to uppercase
UPPER(string: VARCHAR) → VARCHAR sql
| Parameter | Type | Required | Description |
|---|---|---|---|
string | VARCHAR | Yes | Input string to convert |
Notes
- Affects only alphabetic characters
- Non-alphabetic characters remain unchanged
- Handles Unicode characters correctly
Examples
FeatureQL
SELECT
f1 := UPPER('hello world'), -- All lowercase to uppercase
f2 := UPPER('Mixed Case String'), -- Mixed case to uppercase
f3 := UPPER('abc123xyz'), -- Letters and numbers
f4 := UPPER('café'), -- Unicode characters
f5 := UPPER('123!@#') -- Numbers and symbols unchanged
;Result
| f1 VARCHAR | f2 VARCHAR | f3 VARCHAR | f4 VARCHAR | f5 VARCHAR |
|---|---|---|---|---|
| HELLO WORLD | MIXED CASE STRING | ABC123XYZ | CAFÉ | 123!@# |
On this page