Returns the result of the argument character expression after converting all the characters to lowercase. LCASE is the same as LOWER but provides ODBC‑compatible syntax.

Syntax

LCASE ( char_expression )

Notes

  • The argument to the function must be of type CHARACTER.
  • The result is of type CHARACTER.
  • If the argument expression evaluates to NULL, the result is NULL.
  • A char_expression and the result can contain multi‑byte characters. The lowercase conversion is determined by the case table in the convmap file. The default case table is BASIC.

Example

This example illustrates the LCASE function:

SELECT *
    FROM customer
    WHERE LCASE (last_name) = 'smith' ;

Compatibility

ODBC compatible