Difference between revisions of "ENDSWITH()"

From Lianjapedia
Jump to: navigation, search
 
 
(5 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 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()]], [[Relational Operators]], [[SEEK]], [[SEEK()]], [[SET EXACT]], [[STARTSWITH()]], [[SUBSTRINGOF()]], [[TYPE()]], [[UPPER()]], [[VARTYPE()]]
+
[[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 16: 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="30%"|Parameters||Description
!Parameters||Description
+
 
|-
 
|-
 
|<expC1>||The character string to be searched.
 
|<expC1>||The character string to be searched.
Line 25: Line 21:
 
|-
 
|-
 
|}
 
|}
 
  
 
==Example==
 
==Example==
Line 31: Line 26:
 
open database southwind
 
open database southwind
 
use orders
 
use orders
browse for endswith(customerid,"AT")
+
list for endswith(customerid,"AT")
 
</code>
 
</code>
  
 
==Products==
 
Recital Server, Recital
 
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:String Data]]
 
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]
 +
[[Category:Lianja VFP Extensions]]
 +
[[Category:VFP Function Extensions]]

Latest revision as of 06:33, 4 February 2013

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")