Skip to main content

UPPER

Returns an input string in uppercase.

See also:
[SELECT] [LOWER] [ Data Types ]


Syntax​

SELECT UPPER(character_expression) FROM <multipartIdentifier>;

The upper() function works for ASCII characters only.

Arguments​

character_expression
An ASCII string.

Return Value(s)​

Returns a string value.


Examples​

Return a string in uppercase​

SELECT UPPER(name), location FROM google.storage.buckets WHERE project = 'stackql-demo';

For more information, see https://www.sqlite.org/lang_corefunc.html#upper