Home » Tutorials » SQL » SQL LCASE Function

SQL LCASE Function

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 Road

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


Link/cite this page

If you use any of the content on this page in your own work, please use the code below to cite this page as the source of the content.

  • Stewart, Suzy. "SQL LCASE Function". After Hours Programming. Accessed on January 21, 2022. https://www.afterhoursprogramming.com/tutorial/sql/sql-lcase-function/.

  • Stewart, Suzy. "SQL LCASE Function". After Hours Programming, https://www.afterhoursprogramming.com/tutorial/sql/sql-lcase-function/. Accessed 21 January, 2022.

  • Stewart, Suzy. SQL LCASE Function. After Hours Programming. Retrieved from https://www.afterhoursprogramming.com/tutorial/sql/sql-lcase-function/.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.