LOWER Function

Converts a string to lowercase.

Category: String
Returned data type: String

Syntax

LOWER(source)

Required Argument

source

specifies a string; this can be specified as string constant, field name, or expression.

Note If source is NULL, the function returns a NULL value.

Example

source = "MÜNCHEN in Germany"
lowcase_string = lower(source) // outputs "münchen in germany"