LOWER( ) function

Returns a string with alphabetic characters converted to lowercase.

Syntax

LOWER(string)

Parameters

Name	Type	Description
string	character	The value to convert to lowercase.

Output

Character.

Examples

Basic examples

Returns "abc":

LOWER("ABC")

Returns "abc 123 def":

LOWER("abc 123 DEF")

Returns "abcd 12":

LOWER("AbCd 12")

Returns all the values in the Last_Name field converted to lowercase:

LOWER(Last_Name)

Remarks

How it works

The LOWER( ) function converts all alphabetic characters in string to lowercase. All non-alphabetic characters are left unchanged.

When to use LOWER( )

Use LOWER( ) when you search for data that is in mixed or unknown case, or when you want data formatted as lowercase text.