Difference between revisions of "CONTAINS()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 6: | Line 6: | ||
==Syntax== | ==Syntax== | ||
| − | CONTAINS(<expC>,<expL>) | + | CONTAINS(<expC>,<expL>|<expN>) |
| Line 25: | Line 25: | ||
|- | |- | ||
|<expL>||. | |<expL>||. | ||
| + | |- | ||
| + | |<expN>||. | ||
|- | |- | ||
|} | |} | ||
Revision as of 11:54, 17 November 2010
Purpose
Function to determine whether the current record contains a specified character string
Syntax
CONTAINS(<expC>,<expL>|<expN>)
See Also
CHROVERLAP(), EMPTY(), EVALUATE(), EXPRCHECK(), FOR(), INDEX, INLIST(), INRANGE(), ISALPHA(), ISBLANK(), ISDIGIT(), MAX(), MAXVALUES(), MIN(), MINVALUES(), TYPE(), VARTYPE()
Description
The CONTAINS() function returns true (.T.) if the current record contains the specified character string, <expC>.
CONTAINS() performs a case-insensitive search of the record's character and memo fields.
| Parameters | Description |
|---|---|
| <expC> | The character string to search for. |
| <expL> | . |
| <expN> | . |
Example
open database southwind use customers // Restrict index to records containing string "USA" index on lower(companyname) for contains("USA",.F.)
Products
Recital Server, Recital
