Difference between revisions of "INDEXOF()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 14: | Line 14: | ||
The INDEXOF() function returns the numeric position of the first occurrence of the specified character string, <expC2>, in another character string, <expC1>. | 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. | + | A case-sensitive search is performed. Character positions start from 1, if the string <expC2> is not found, INDEXOF() returns 0. |
| Line 39: | Line 39: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | [[Category: | + | [[Category:String Data]] |
| − | [[Category: | + | [[Category:String Data Functions]] |
Latest revision as of 10:41, 13 June 2011
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
