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.
LCASE ( string )
LOWER ( string )
string :
• character string
• NULL
SELECT LOWER('');
lower('')
======================
''
SELECT LOWER(NULL);
lower(null)
======================
NULL
SELECT LOWER('Cubrid');
lower('Cubrid')
======================
'cubrid'