LOWER Function

Converts a string to lowercase.

Category: String
Returned data type: String

Syntax

LOWER(source)

Required Argument

source

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

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

Example

source = "MÜNCHEN in Germany"

lowcase_string = lower(source) // outputs "münchen in germany"