Help Center> Data Lake Insight> SQL Syntax Reference (To Be Offline)> Spark SQL Syntax Reference (Unavailable Soon)> Built-in Functions> String Functions> upper/ucase
Updated on 2023-10-25 GMT+08:00
View PDF

upper/ucase

This function is used to convert all characters of a string to the upper case.

Syntax

upper(string A)

or

ucase(string A)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

A

Yes

STRING

Text string to be converted

Return Values

The return value is of the STRING type.

  • If the value of the input parameter is not of the STRING, BIGINT, DOUBLE, DECIMAL, or DATETIME type, an error is reported.
  • If the value of the input parameter is NULL, NULL is returned.

Example Code

Converts lowercase characters in a string to the upper case. An example command is as follows:

The value ABC is returned.

select upper('abc');

The value of the input parameter is NULL. An example command is as follows:

The value NULL is returned.

select upper(null);
Parent topic: String Functions