LCASE or LOWER (string)
Converts all upper case characters in a string to lower case.
Changes the case of the first name to lowercase and then to upper case, and results in "roosevelt", "ROOSEVELT".
SELECT LCASE(First_name),UCASE(First_name) FROM Person WHERE First_name = 'Roosevelt'
Thursday, 18 April 2019 Posted in String Functions