Difference between revisions of "STARTSWITH()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 13: | Line 13: | ||
A case-sensitive search is performed. The current [[SET EXACT]] setting has no effect. | A case-sensitive search is performed. The current [[SET EXACT]] setting has no effect. | ||
| − | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
| − | !width=30%|Parameters||Description | + | !width="30%"|Parameters||Description |
|- | |- | ||
|<expC1>||The character string to be searched. | |<expC1>||The character string to be searched. | ||
| Line 31: | Line 31: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| − | |||
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
[[Category:Lianja VFP Extensions]] | [[Category:Lianja VFP Extensions]] | ||
[[Category:VFP Function Extensions]] | [[Category:VFP Function Extensions]] | ||
Latest revision as of 06:46, 4 February 2013
Contents
Purpose
Function to perform a case-sensitive search of a string to determine if it starts with a specified character string
Syntax
STARTSWITH(<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, TYPE(), UPPER(), VARTYPE()
Description
The STARTSWITH() function returns .T. (True) if the character string <expC1> starts with the specified character string, <expC2>.
A case-sensitive search is performed. The current SET EXACT setting has no effect.
| Parameters | Description |
|---|---|
| <expC1> | The character string to be searched. |
| <expC2> | The character string to search for. |
Example
open database southwind use orders list for startswith(customerid,"BON")
