Print      Open PDF Version of Online Help

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

Previous Topic

Next Topic

Right

The Right function in Expression Builder returns a specified number of characters from the right side of a string.

Syntax

Right(string, length)

Result Type

String

Arguments

The following table describes the arguments for the function.

Argument

Description

string

The string from which the rightmost characters are returned. If the string contains Null, Null is returned.

length

An integer indicating the number of characters to return. If this argument is 0 (zero), a blank string is returned. If this argument is greater than or equal to the number of characters in the string, the entire string is returned.

Examples

If the current user's email address is john.doe@oracle.com, the following example returns the value oracle.com:

Right(UserValue('<EMailAddr>'), Len(UserValue('<EMailAddr>'))-InStr(UserValue('<EMailAddr>'),'@'))

Related Topics

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