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
    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
    f6 := UPPER(NULL(VARCHAR)) -- NULL yields NULL
;

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/05/26 17:22:09

On this page

Signatures Notes Examples