UCASE/UPPER

描述

用于将字符串转换为大写字母

语法

UCASE( <str> )
UPPER( <str> )

必选参数

参数	描述
<str>	需转换为大写字母的字符串

返回值

转换大写字母后的值

示例

SELECT UCASE("aBc123"),UPPER("aBc123");

+-----------------+-----------------+
| UCASE("aBc123") | UPPER("aBc123") |
+-----------------+-----------------+
| ABC123          | ABC123          |
+-----------------+-----------------+

SELECT UCASE("Кириллица"),UPPER("Бәйтерек");

+-----------------------------+---------------------------+
| UCASE("Кириллица")          | UPPER("Бәйтерек")         |
+-----------------------------+---------------------------+
| КИРИЛЛИЦА                   | БӘЙТЕРЕК                  |
+-----------------------------+---------------------------+