UCASE/UPPER

Description

Used to convert a string to uppercase letters

Syntax

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

Required Parameters

Parameters	Description
<str>	The string to convert to uppercase

Return Value

The value after converting the uppercase

Example

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

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

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

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