Difference between revisions of "SUBSTRINGOF()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| 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:16, 13 June 2011
Purpose
Function to perform a case-sensitive search of a string to determine if it contains a specified character string
Syntax
SUBSTRINGOF(<expC1>,<expC2>)
See Also
BETWEEN(), CHROVERLAP(), CONTAINS(), EMPTY(), ENDSWITH(), EVALUATE(), EXPRCHECK(), FOR(), INDEX, INDEXOF(), INLIST(), INRANGE(), ISALPHA(), ISBLANK(), ISDIGIT(), LOWER(), MAX(), MAXVALUES(), MIN(), MINVALUES(), MTOS(), PROPER(), Relational Operators, SEEK, SEEK(), SET EXACT, STARTSWITH(), TYPE(), UPPER(), VARTYPE()
Description
The SUBSTRINGOF() function returns .T. (True) if the character string <expC1> contains the specified character string, <expC2>.
A case-sensitive search is performed.
| Parameters | Description |
|---|---|
| <expC1> | The character string to be searched. |
| <expC2> | The character string to search for. |
Example
open database southwind use orders browse for substringof(customerid,"AT")
Products
Recital Server, Recital
