Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

LOWER Function

Description

The LOWER function converts uppercase characters that are included in a character string to lowercase characters; it works the same as the LCASE function. Note that the LOWER function may not work properly in character sets that are not supported by CUBRID. For details about the character sets supported by CUBRID, see Definition and Characteristics.

Syntax

LCASE (string )

LOWER ( string )

 

string :

? character string

? NULL

  • string : Specifies the string in which uppercase characters are to be converted to lowercase. If the value is NULL, NULL is returned.
Example

SELECT LOWER('');

 

======================

  ''

 

SELECT LOWER(NULL);

 

======================

  NULL

 

SELECT LOWER('Cubrid');

 

======================

  'cubrid'