tolower

Returns the string "string_expression" with all the characters converted to lower case using the rules of the locale "locale_string". If no locale is specified, the locale 'en' is used.

Note: Supported only in dynamic query mode.

Syntax

tolower ( string_expression [ , locale_string ] )

Example 1

# tolower ( 'ABC' ) #

Result

abc

Example 2

# tolower ( 'ABC' , 'fr' ) #

Result

abc