ENDSWITH()

From Lianjapedia
Revision as of 06:33, 4 February 2013 by Helen.george (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 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")