Returns the result of the argument char_expression after converting all the characters to lowercase.

Syntax

LOWER ( char_expression )

Example

This example illustrates the LOWER function:

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

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.

Compatibility

SQL compatible