Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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



LCASE/LOWER Functions

Description

The LCASE and LOWER functions are used interchangeably. They convert uppercase characters included in string to lowercase characters. Note that these functions may not work properly in character sets which are not supported by CUBRID. For details on 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('');

  lower('')

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

  ''

 

SELECT LOWER(NULL);

  lower(null)

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

  NULL

 

SELECT LOWER('Cubrid');

  lower('Cubrid')

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

  'cubrid'