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

Syntax

VARCHAR LOWER(A)       

Input parameters

  • A
  • VARCHAR

Description

Converts all the letters in a string to lowercase.

Example

  • Test data
    var1 (VARCHAR)
    Ss
    yyT
  • Test statements
    SELECT LOWER(var1) as aa
    FROM T1;                 
  • Test results
    aa (VARCHAR)
    ss
    yyt