Difference between revisions of "ENDSWITH()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to perform a case-sensitive search of a string to determine if it ends with a specified character string | Function to perform a case-sensitive search of a string to determine if it ends with a specified character string | ||
| − | |||
==Syntax== | ==Syntax== | ||
ENDSWITH(<expC1>,<expC2>) | ENDSWITH(<expC1>,<expC2>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[AT()]], [[BETWEEN()]], [[CHROVERLAP()]], [[CONTAINS()]], [[EMPTY()]], [[EVALUATE()]], [[EXPRCHECK()]], [[FOR()]], [[INDEX]], [[INDEXOF()]], [[INLIST()]], [[INRANGE()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[LOWER()]], [[MAX()]], [[MAXVALUES()]], [[MIN()]], [[MINVALUES()]], [[MTOS()]], [[PROPER() | + | [[AT()]], [[BETWEEN()]], [[CHROVERLAP()]], [[CONTAINS()]], [[EMPTY()]], [[EVALUATE()]], [[EXPRCHECK()]], [[FOR()]], [[INDEX]], [[INDEXOF()]], [[INLIST()]], [[INRANGE()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[LOWER()]], [[MAX()]], [[MAXVALUES()]], [[MIN()]], [[MINVALUES()]], [[MTOS()]], [[PROPER()]], [[SEEK]], [[SEEK()]], [[SET EXACT]], [[STARTSWITH()]], [[SUBSTRINGOF()]], [[TYPE()]], [[UPPER()]], [[VARTYPE()]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 15: | Line 12: | ||
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" | {| class="wikitable" | ||
| Line 25: | Line 21: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 31: | Line 26: | ||
open database southwind | open database southwind | ||
use orders | use orders | ||
| − | + | list for endswith(customerid,"AT") | |
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:String Data]] | [[Category:String Data]] | ||
[[Category:String Data Functions]] | [[Category:String Data Functions]] | ||
Revision as of 13:09, 10 February 2012
Contents
Purpose
Function to perform a case-sensitive search of a string to determine if it ends with a specified character string
Syntax
ENDSWITH(<expC1>,<expC2>)
See Also
AT(), BETWEEN(), CHROVERLAP(), CONTAINS(), EMPTY(), EVALUATE(), EXPRCHECK(), FOR(), INDEX, INDEXOF(), INLIST(), INRANGE(), ISALPHA(), ISBLANK(), ISDIGIT(), LOWER(), MAX(), MAXVALUES(), MIN(), MINVALUES(), MTOS(), PROPER(), SEEK, SEEK(), SET EXACT, STARTSWITH(), SUBSTRINGOF(), TYPE(), UPPER(), VARTYPE()
Description
The ENDSWITH() function returns .T. (True) if the character string <expC1> ends 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 endswith(customerid,"AT")
