LOWER

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

Syntax

LOWER ( char_expression )

This example illustrates the LOWER function:

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

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.

SQL compatible