Home /SQL/SQL LCASE Function

SQL LCASE Functions

The LCASE() function converts the value of a field to lowercase.

SQL LCASE() Syntax

SELECT LCASE(column_name) FROM table_name

Now we want to select the content of the "LastName" and "FirstName" columns above, and convert the "LastName" column to lowercase.

IDLastNameFirstNameAddressCity
1SmithJohn22 StreetLondon
2JonesMary55 AvenueNew York
3WatsonAlfred66 RoadLondon

We use the following SELECT statement:

SELECT LCASE(LastName) as LastName,FirstName FROM Persons

The result-set will look like this:

LastNameFirstName
smithJohn
jonesMary
watsonAlfred