Print      Open PDF Version of Online Help

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

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.

NOTE: The language-independent field names and the field-name syntax used in any example expressions in this topic are the field names and the field-name syntax that were used in Expression Builder in releases earlier than Release 29 Service Pack 1. These examples are still valid. However, if you select the corresponding fields for an expression from the Fields list in Expression Builder in Release 29 Service Pack 1 or later, then the field names and the field-name syntax will be different from those shown in the examples. It is recommended that you always select the fields for your expressions from the Fields list in Expression Builder, so that the field names and the field-name syntax are always correct. For more information about the field names and the field-name syntax in expressions, see About Expressions.

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:

• About Expression Builder
• Using Expression Builder
• Expression Builder Functions