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

Letters become uppercase; digits, punctuation, and most symbols stay unchanged
UPPER('') is ''; if the input is NULL the result is NULL (use NULL(VARCHAR); bare NULL fails inference)

Examples

FeatureQL

SELECT
    -- All lowercase to uppercase
    f1 := UPPER('hello world'),
    -- Mixed case to uppercase
    f2 := UPPER('Mixed Case String'),
    -- Letters and numbers
    f3 := UPPER('abc123xyz'),
    -- Unicode characters
    f4 := UPPER('café'),
    -- Numbers and symbols unchanged
    f5 := UPPER('123!@#'),
    -- NULL yields NULL
    f6 := UPPER(NULL(VARCHAR))
;

Result

f1 VARCHAR	f2 VARCHAR	f3 VARCHAR	f4 VARCHAR	f5 VARCHAR	f6 VARCHAR
HELLO WORLD	MIXED CASE STRING	ABC123XYZ	CAFÉ	123!@#	NULL

Suggest changes to this page

Last update at: 2026/06/20 10:08:10

On this page

Signatures Notes Examples