Difference between revisions of "STARTSWITH()"

From Lianjapedia
Jump to: navigation, search
Line 33: Line 33:
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[Category:String Data Functions]]
 +
[[Category:Lianja VFP Extensions]]
 +
[[Category:VFP Function Extensions]]

Revision as of 07:18, 10 December 2012

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