Print      Open PDF Version of Online Help

Administering Oracle CRM On Demand > Expression Builder > Expression Builder Functions > Lower

Previous Topic

Next Topic

Lower

The Lower function in Expression Builder converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.

Syntax

Lower(string)

Result Type

String

Arguments

The following table describes the arguments for the function.

Argument

Description

string

Specifies the string that is to be converted. The value can be a string literal, or a field name, or an expression that returns a string. If the value is a string literal, then it must be enclosed in single or double quotation marks.

Examples

If the First Name field on a contact record contains the value Amanda, then the following example returns the value amanda:

Lower([{First Name}])

The following examples both return the value account123:

Lower('Account123')

Lower("Account123")

Related Topics

See the following topics for related Expression Builder information:
Published 1/9/2017 Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices.