Product SiteDocumentation Site

7.4.42. LOWER


>>-LOWER(string-+----------------------------+--)--------------><
                +--,--+-----+--+-----------+-+
                      +--n--+  +--,length--+

Returns a new string with the characters of string beginning with character n for length characters converted to lowercase. If n is specified, it must be a positive whole number. If n is not specified, the case conversion will start with the first character. If length is specified, it must be a non-negative whole number. If length is not specified, the default is to convert the remainder of the string.
Examples:

Example 7.56. Builtin function LOWER

lower("Albert Einstein")      ->    "albert einstein"
lower("ABCDEF", 4)            ->    "ABCdef"
lower("ABCDEF", 3, 2)         ->    "ABcdEF"