search by converting to lowercase sql code example

Example: how to write lowercase in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;