INSTR(string_exp1$, string_exp2$) INSTR(start_pos, string_exp1$, string_exp2$)

 

Returns a Numeric Value
Returns the position of the first occurrence of string_exp2$ in string_exp1$. Returns 0 if string_exp2$ is not found. If start_pos is specified (in the alternate form), the search begins at start_pos. This function is case sensitive.

Examples:

INSTR("HELLO WORLD","OR")

Returns 8.

INSTR("HELLO WORLD","O")

Returns 5.

INSTR(7,"HELLO WORLD","O")

Returns 8.

Other Resources

• Expression Examples
• Filtering Records
• Knowledge Base Article R11493 - All About Expressions
• Knowledge Base Article R11515 - Filter Expression Examples
• Knowledge Base Article R11487 - Working with Indexes, Filters, and QuickViews
• Knowledge Base Article R10750 - Report Writer, Filter, and WorkFlow Functions (provides link to downloadable .pdf)

 

See also:

FIND( )