WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

SQL LCASE() Function


The LCASE() Function

The LCASE() work changes over the estimation of a field to lowercase.

SQL LCASE() Syntax

SELECT LCASE(column_name) FROM table_name;

Syntax for SQL Server

SELECT LOWER(column_name) FROM table_name;

Database

In this instructional exercise we will utilize the notable example database.

Below is a choice from the "Clients" table:

CustomerID CustomerName Phone Address City Country
1

Ramonita Homan 231-596-2048 ORubaiyat Road Fantastic Rapid MI USA
2 Charles L. Emmons 507-256-8113 Rosewood Court Clarks Grove MN USA
3 Ruth C. Dorsey 079 1763 2524 Quay Street NAILBRIDGE YO4 5SS UK/td>
4

Evelyn B. Blacker 077 6011 6540 Wade Lane SAND HOLE YO4 5SS UK
5 Nytorpsvägen 45 Christina Berglund Nytorpsvägen 45 BANKERYD Sweden

SQL LCASE() Example

The following SQL articulation chooses the "CustomerName" and "City" sections from the "Clients" table, and changes over the "CustomerName" section to lowercase:

Example

SELECT LCASE(CustomerName) AS Customer, City
FROM Customers;