| Print Open PDF Version of Online Help

#### 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 be returned. 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.co.uk, the following example returns the value john: Left(UserValue('<EMailAddr>'), 4) #### Related Topics See the following topics for related Expression Builder information: About Expression Builder Using Expression Builder Expression Builder Functions

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.