- Categories:
String & Binary Functions (Case Conversion)
UPPER¶
Returns the input string expr
with all characters converted to uppercase.
Syntax¶
UPPER( <expr> )
Collation Details¶
Arguments with collation specifications are currently not supported.
Examples¶
SELECT v, UPPER(v) FROM lu;
----------------------------------+----------------------------------+
v | upper(v) |
----------------------------------+----------------------------------+
| |
1č2Щ3ß4Ę!-?abc@ | 1Č2Щ3SS4Ę!-?ABC@ |
AaBbCcDdEeFfGgHhIiJj | AABBCCDDEEFFGGHHIIJJ |
KkLlMmNnOoPpQqRrSsTt | KKLLMMNNOOPPQQRRSSTT |
UuVvWwXxYyZz | UUVVWWXXYYZZ |
ÁáÄäÉéÍíÓóÔôÚúÝý | ÁÁÄÄÉÉÍÍÓÓÔÔÚÚÝÝ |
ÄäÖößÜü | ÄÄÖÖSSÜÜ |
ÉéÀàÈèÙùÂâÊêÎîÔôÛûËëÏïÜüŸÿÇçŒœÆæ | ÉÉÀÀÈÈÙÙÂÂÊÊÎÎÔÔÛÛËËÏÏÜÜŸŸÇÇŒŒÆÆ |
ĄąĆćĘꣳŃńÓóŚśŹźŻż | ĄĄĆĆĘĘŁŁŃŃÓÓŚŚŹŹŻŻ |
ČčĎďĹ弾ŇňŔ੹ŤťŽž | ČČĎĎĹĹĽĽŇŇŔŔŠŠŤŤŽŽ |
АаБбВвГгДдЕеЁёЖжЗзИиЙй | ААББВВГГДДЕЕЁЁЖЖЗЗИИЙЙ |
КкЛлМмНнОоПпРрСсТтУуФф | ККЛЛММННООППРРССТТУУФФ |
ХхЦцЧчШшЩщЪъЫыЬьЭэЮюЯя | ХХЦЦЧЧШШЩЩЪЪЫЫЬЬЭЭЮЮЯЯ |
[NULL] | [NULL] |
----------------------------------+----------------------------------+