Published on: 26 September, 2013


Posted by andy | 1729 views 0 likes 0 favourites 0 comments
Tumblr Digg Google Plus

The SQL LCASE() function is used to convert a text or string value to lower case values.

Example Customer Table

The following data table is for example only. Let's use LCASE() function to convert the customer name to all lower case. The column we going to use is the Name column.

ID Name Age
1 Thomas Anderson 45
2 Andrew Golden 38
3 Ken Tom 30
4 Andrew Golden 36
5 Timonthy Kirk 32
6 Kelly Smith 39

Example of Running SQL Query

FROM   Customers

After running the above query, it will return the following result.

ID Name Age
1 thomas anderson 45
2 andrew golden 38
3 ken tom 30
4 andrew golden 36
5 timonthy kirk 32
6 kelly smith 39

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.
Related Articles
Published on: 25 September, 2017
When creating a function dynamically, it is a best practice to perform a check if a particular function you want to create has already existed in a database. To perform a check of an existing function you can use the following EXISTS keyword. If the function does not exist then perform a creation of the function.
Published on: 12 May, 2016
Do you need to sort comments with nested replies in SQL Server? Well this can be easily done by combining the same table using the UNION ALL join to populate the comments content. There is a trick to used to sort the comments which use the combination of a record ID field with the row number index.
Published on: 14 April, 2016
Before running an SQL script to create a table dynamically, it would be a good step if you perform a checking if a table already exists. If it does, you may want to skip creating the table otherwise you will get an error exception.