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

Example

SELECT LOWER('');

  lower('')

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

  ''

 

SELECT LOWER(NULL);

  lower(null)

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

  NULL

 

SELECT LOWER('Cubrid');

  lower('Cubrid')

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

  'cubrid'