This topic describes how to use the string function UPPER in Realtime Compute.

Syntax

VARCHAR UPPER(A)     

Input parameters

Parameter Data type
A VARCHAR

Description

Converts all the letters in a string to uppercase.

Example

  • Test data
    var1 (VARCHAR)
    ss
    ttee
  • Test statements
    SELECT UPPER(var1) as aa
    FROM T1;            
  • Test results
    aa (VARCHAR)
    SS
    TTEE