Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Left

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

Syntax

Left(string, length)

Result Type

String

Arguments

The following table describes the arguments for the function.

Argument

Description

string

The string from which the leftmost 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 john:

Left(UserValue('<EMailAddr>'), 4)

Related Topics

See the following topics for related Expression Builder information:


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.