SQL LOWER Function

The LOWER function converts a string to lowercase.

To convert a string to uppercase use the UPPER function.

Example

#

This example converts the input string to lowercase.

SELECT LOWER('Los Angeles') AS City
Result:  1 record
City
los angeles

Syntax

Syntax of the LOWER function.

LOWER(string)

string -- a character expression, variable, or column name.


More Examples

LOWER with Table Columns

CUSTOMER
Id
FirstName
LastName
City
Country
Phone
Problem: List customers with lowercase names.
SELECT LOWER(FirstName + ' ' + LastName) AS Name, 
       City, Country
  FROM Customer
Result:  91 records
Name City Country
maria anders Berlin Germany
ana trujillo México D.F. Mexico
antonio moreno México D.F. Mexico
tdomas hardy London UK
christina berglund Luleå Sweden

You may also like



Guides


vsn 3.1