The LCASE() function converts the value of a field to lowercase.
We have the following "Persons" table:
Now we want to select Content of the "LastName" and "FirstName" columns
above, and convert the "LastName" column to lowercase.
We use the following SELECT statement:
The result-set will look like this:
Your Query was successfully sent!