Skip to main content
Version: 2.5

upper

Description​

Converts a string to upper-case.

Syntax​

upper(str)

Parameters​

  • str: the string to convert. If str is not a string type, it will try implicit cast first.

Return value​

Return an upper-case string.

Examples​

MySQL [test]> select C_String, upper(C_String) from ex_iceberg_tbl;
+-------------------+-------------------+
| C_String          | upper(C_String)   |
+-------------------+-------------------+
| Hello, StarRocks! | HELLO, STARROCKS! |
| Hello, World!     | HELLO, WORLD!     |
+-------------------+-------------------+