Learn From - Interactive SQL


Next Chapter »

SQL LOWER() Function


LOWER() function converts the values of the specified text column to loweer case.

SQL LOWER() Syntax


SELECT LOWER(column_name)
FROM table_name

Below is shown the "Authors" table:

FirstName LastName Address City
White Michael 22 Cleveland Av. #24 Berkeley
Hunter Sheryl NULL Salt Lake City
Smith Charlene NULL San Francisco
Jhonson Fernandis 2286 Cram Pl. #81 NULL
Robert Paul 1976 Arlington Pl. NULL

SQL LOWER() Example


Text Editor below has the SQL Query, click the "View Result" button, to see the result.

To convert the value of the FirstName column to lower case.

Select LOWER(FirstName), LastName from Authors;

SQL in Text Editor:








Next Chapter »