Skip to main content
Converts the input string to uppercase characters. Note that Firebolt uses the POSIX locale, therefore upper only converts the ASCII characters “a” through “z” to uppercase. Non-ASCII characters remain unchanged.

​
Syntax

UPPER(<expression>)

​
Parameters

ParameterDescriptionSupported input types
<expression>The string to be converted to uppercase characters.TEXT

​
Return Type

TEXT

​
Example

The following example converts a game player’s username from lowercase to uppercase characters: 
SELECT
	UPPER('esimpson') as username
Returns: ESIMPSON Because Firebolt uses the POSIX locale, non-ASCII characters are not uppercased: 
SELECT UPPER('München')
Returns: MüNCHEN