Product SiteDocumentation Site

7.4.69. UPPER


>>-UPPER(string-+----------------------------+--)--------------><
                +--,--+-----+--+-----------+-+
                      +--n--+  +--,length--+

Returns a new string with the characters of string beginning with character n for length characters converted to uppercase. If n is specified, it must be a positive whole number. If n is not specified, the case conversion will start with the first character. If length is specified, it must be a non-negative whole number. If length is not specified, the default is to convert the remainder of the string.

Example 7.95. Builtin function UPPER

upper("Albert Einstein")      ->    "ALBERT EINSTEIN"
upper("abcdef", 4)            ->    "abcDEF"
upper("abcdef", 3, 2)         ->    "abCDef"