Difference between revisions of "INDEXOF()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(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:Expressions and Type Conversion]]
+
[[Category:String Data]]
[[Category:Expressions and Type Conversion Functions]]
+
[[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