LOWER function

LOWER(text) LOWER(text)

text — Text or { Text }

The text string whose upper-case characters should be replaced by equivalent lower-case characters.

Returns — Text or { Text }

A version of the given text string with all upper-case characters replaced by equivalent lower-case characters.

Converts all upper-case letters in a text string to lower-case letters and returns the converted string.



Returns "abc".

CONTAINS(LOWER(TextField1), LOWER(TextField2))CONTAINS(LOWER(TextField1); LOWER(TextField2))

Returns whether the value of TextField1 contains the value of TextField2. The comparison is case-insensitive, as both parameters are made lower-case before being passed to CONTAINS.