STARTSWITH()
From Recital Documentation Wiki
Revision as of 10:16, 13 June 2011 by Yvonnemilne (Talk | contribs)
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(), Relational Operators, 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 browse for startswith(customerid,"BON")
Products
Recital Server, Recital