8.3.18. UPPER()
Available in
DSQL, ESQL, PSQL
Syntax
UPPER (str)
Parameter | Description |
---|---|
str | An expression of a string type |
Result type
(VAR)CHAR
or BLOB
Description
Returns the upper-case equivalent of the input string. The exact result depends on the character set. With ASCII
or NONE
for instance, only ASCII characters are uppercased; with OCTETS
, the entire string is returned unchanged. Since Firebird 2.1 this function also fully supports text BLOB
s of any length and character set.
Examples
select upper(_iso8859_1 'Débâcle')
from rdb$database
-- returns 'DÉBÂCLE' (before Firebird 2.0: 'DéBâCLE')
select upper(_iso8859_1 'Débâcle' collate fr_fr)
from rdb$database
-- returns 'DEBACLE', following French uppercasing rules
See also