INDEXOF()

Purpose

Function to return the numeric position of the first occurrence of a specified character string in another character string

Syntax

INDEXOF(<expC1>,<expC2>)

See Also

BETWEEN(), CHROVERLAP(), CONTAINS(), EMPTY(), ENDSWITH(), EVALUATE(), EXPRCHECK(), FOR(), INDEX, INLIST(), INRANGE(), ISALPHA(), ISBLANK(), ISDIGIT(), LOWER(), MAX(), MAXVALUES(), MIN(), MINVALUES(), MTOS(), PROPER(), Relational Operators, SEEK, SEEK(), SET EXACT, STARTSWITH(), SUBSTRINGOF(), TYPE(), UPPER(), VARTYPE()

Description

The INDEXOF() function returns the numeric position of the first occurrence of the specified character string, <expC2>, in another character string, <expC1>.

A case-sensitive search is performed. Character positions start from 1, if the string <expC2> is not found, INDEXOF() returns 0.

Parameters	Description
<expC1>	The character string to be searched.
<expC2>	The character string to search for.

Example

open database southwind
use orders
browse for indexof(customerid,"AT") = 3

Products

Recital Server, Recital