INDEXOF()

From Lianjapedia
Jump to: navigation, search

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(), 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
list for indexof(customerid,"AT") = 3