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