Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Len

The Len function in Expression Builder returns the number of characters in a specified string.

Syntax

Len(string)

Result Type

Integer

Arguments

The following table describes the arguments for the function.

Argument

Description

string

The field name or string expression from which the characters are counted. If the string is blank, 0 (zero) is returned. If the string contains Null, Null is returned.

Examples

The following example returns the value 18:

Len("Oracle Corporation")

The following example returns the value 19 if the field contains a valid timestamp:

Len([<CreatedDate>])

The following example returns the value 19:

Len(Timestamp()) returns 19

Related Topics

See the following topics for related Expression Builder information:


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