Print      Open PDF Version of Online Help


Previous Topic

Next Topic

InStr Function

The InStr function in Expression Builder returns the position of the first occurrence of one string within another.

Syntax

Instr(string1, string2, start, end)

Result Type

Integer

Arguments

The following table describes the arguments for the function.

Argument

Description

string1

Specifies the string that is to be searched. The value can be a string literal, or a field name, or an expression that returns a string.

string2

Specifies the string that is to be searched for. The value can be a string literal, or a field name, or an expression that returns a string.

start

(Optional) An integer that specifies the start point in string1.

end

(Optional) An integer that specifies the end point in string1.

Examples

The following example returns the value 9:

InStr('john.doe@oracle.com','@')

Related Information

See the following topics for related Expression Builder information:


Published May 2008