Difference between revisions of "SUBSTRINGOF()"
From Lianjapedia
Helen.george (Talk | contribs) |
|||
| (4 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to perform a case-sensitive search of a string to determine if it contains a specified character string | Function to perform a case-sensitive search of a string to determine if it contains a specified character string | ||
| − | |||
==Syntax== | ==Syntax== | ||
SUBSTRINGOF(<expC1>,<expC2>) | SUBSTRINGOF(<expC1>,<expC2>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[BETWEEN()]], [[CHROVERLAP()]], [[CONTAINS()]], [[EMPTY()]], [[ENDSWITH()]], [[EVALUATE()]], [[EXPRCHECK()]], [[FOR()]], [[INDEX]], [[INDEXOF()]], [[INLIST()]], [[INRANGE()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[LOWER()]], [[MAX()]], [[MAXVALUES()]], [[MIN()]], [[MINVALUES()]], [[MTOS()]], [[PROPER() | + | [[BETWEEN()]], [[CHROVERLAP()]], [[CONTAINS()]], [[EMPTY()]], [[ENDSWITH()]], [[EVALUATE()]], [[EXPRCHECK()]], [[FOR()]], [[INDEX]], [[INDEXOF()]], [[INLIST()]], [[INRANGE()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[LOWER()]], [[MAX()]], [[MAXVALUES()]], [[MIN()]], [[MINVALUES()]], [[MTOS()]], [[PROPER()]], [[SEEK]], [[SEEK()]], [[SET EXACT]], [[STARTSWITH()]], [[TYPE()]], [[UPPER()]], [[VARTYPE()]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 16: | Line 13: | ||
A case-sensitive search is performed. | A case-sensitive search is performed. | ||
| − | + | {| class="wikitable" width="100%" | |
| − | {| class="wikitable" | + | |
!Parameters||Description | !Parameters||Description | ||
|- | |- | ||
| Line 25: | Line 21: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 31: | Line 26: | ||
open database southwind | open database southwind | ||
use orders | use orders | ||
| − | + | list for substringof(customerid,"AT") | |
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
| + | [[Category:Lianja VFP Extensions]] | ||
| + | [[Category:VFP Function Extensions]] | ||
Latest revision as of 06:59, 4 February 2013
Contents
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(), 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 list for substringof(customerid,"AT")
