STARTSWITH()

From Recital Documentation Wiki
Revision as of 09:38, 13 June 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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