Code has been added to clipboard!

Learn Using SQL Lowercase Function in Databases and Servers

Reading time 1 min
Published Aug 9, 2017
Updated Oct 11, 2019

SQL Lowercase Function: Main Tips

  • This function changes the text field value to lowercase.

Lowercase Function

Syntax of SQL LOWER

Example
SELECT LOWER(col_name) FROM tbl_name;

Syntax of SQL Server

Example
SELECT LOWER(col_name) FROM tbl_name;

Demo Database

In the below table there is a piece of  "Customer" table:

ID Name Contact Address City Postal_Code Country
1 Ben Choplinks Ben Choplink Obeesre Str. 51 Rome 11207 Italy
2 Donald Rich Donald Richario Avda. de la Confgfstitución 4122 Tallin 17021 Estonia
3 Lilly Smilkins Lilly Smilkin Matadsderos 2312 Eguero 14023 Mexico
4 Brandinina Tom Hitchins 110 Hanegover Sq. London WB2 2DP UK
5 Carizmos Christiano Kerrys Berguvsesvägen 9 Luleå S-968 43 Sweden

SQL LOWER: Example

In the code example below we pick out columns "CustomersName" and "CityID" in the table "Customer" and change the "CustomersName" to lowercase:

Example
SELECT LOWER(Name) AS Customers, City
FROM Customers;
Learn SQL
Introduction
Syntax
Data Types
Server Data Types
Commands
Commands List
Wildcards
Constraints
Aggregate Functions
Date Functions
Date Format
Injection
SQL Server Hosting
Views
Auto-incrementation
SQL Operators
AS
AND & OR
IN
BETWEEN
WHERE
GROUP BY
HAVING
ORDER BY
LIKE
NOT
NOT EQUAL
UNION
NULL
NOT NULL
DEFAULT
UNIQUE
FOREIGN KEY
PRIMARY KEY
CHECK
Indexes
ALTER TABLE
CREATE DATABASE
CREATE TABLE
DELETE
DROP
INSERT INTO SELECT
INSERT INTO
SELECT
SELECT DISTINCT
SELECT INTO
SELECT TOP
UPDATE
FULL OUTER JOIN
INNER JOIN
JOIN
LEFT JOIN
RIGHT JOIN
AVG()
COUNT
FIRST
LAST
MAX
MIN()
SUM()
LEN
UCASE
MID
NOW
ROUND
FORMAT
LOWER
CONVERT
ISNULL