To output a string in lowercase

This function converts uppercase characters in a text to lowercase. Other characters stay untouched.

This can be useful for comparing strings or for correcting misspellings, for example in names, labels, or for temporarily unifying text for further processing.

Syntax

lower(string)

Return

string

Examples

lower("LOwER")

Result: lower

contains(lower("With Ninox you can build great databases"), lower("DATABASE"))

Result: Yes (true)

See also

upper which returns a string in uppercase.