LOWER( ) function

Returns a string with alphabetic characters converted to lowercase.

Syntax

LOWER(string)

Parameters

Name	Type	Description
string	character	The field, expression, or literal 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.