Lower

Use this function to convert all alphabetic characters to lowercase characters and return the result.

Syntax

Lower (String, Length)

Parameter

Description

String

Enter a valid string. The default is the value of the current field.

Length

Specify the desired length of output. The default is the length of the input string.

If the length you specify is longer than the string, the string is increased to the given length. If the specified length is less than the string, the length of the string is used. The string is not truncated.

Example

Here are some examples:

(Assume the current field contains the text Your Name.)

Function

Result

Explanation

Lower ( )

"your name"

Defaults to the current field

Lower ("Street Address")

"street address"

Lowercases the given string

Lower ( , 15)

"your name "

Lowercases the current field and increases the length to 15

See also

© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents