meta data for this page
UPPER()
Available in: DSQL, ESQL, PSQL
Added in: IB
Changed in: 2.0, 2.1
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 BLOBs of any length and character set.
Result type: (VAR)CHAR or BLOB
Syntax
UPPER (str)
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