LOWER function

LOWER (Text) LOWER (Text)

Text

Text Text

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

Text 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.

LOWER ("ABc")

Returns "abc".

CONTAINS ( LOWER ("TESTING"), LOWER ("ing"))

CONTAINS ( LOWER ("TESTING"); LOWER ("ing"))

Returns whether "TESTING" contains "ing". The comparison is case-insensitive, as both parameters are made lower-case before being passed to CONTAINS.