SQL LCASE() Function

The LCASE() Function

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

SQL LCASE() Syntax

SELECT LCASE(column_name) FROM 

SQL LCASE() Example

We have the following "Persons" table:

P_Id LastName FirstName Address City
1 Hansen Ola Timoteivn 10 Sandnes
2 Svendson Tove Borgvn 23 Sandnes
3 Pettersen Kari Storgt 20 Stavanger

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

We use the following SELECT statement:

SELECT LCASE(LastName) as LastName,FirstName
 FROM Persons

The result-set will look like this:

LastName FirstName
hansen Ola
svendson Tove
pettersen Kari
SQL LCASE() Function Reviewed by 1000sourcecodes on 01:16 Rating: 5
Powered by Blogger.