Skip to main content
Version: Latest-3.3

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 values

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! |
+-------------------+-------------------+