CONTAINS()
Contents
Purpose
Function to perform a case-insensitive search of a record's character and memo (optional) fields for a specified character string
Syntax
CONTAINS(<expC>,[<expL>|<expN>])
See Also
BETWEEN(), CHROVERLAP(), EMPTY(), EVALUATE(), EXPRCHECK(), FOR(), HTML_TOPLAINTEXT(), INDEX, INLIST(), INRANGE(), ISALPHA(), ISBLANK(), ISDIGIT(), LOWER(), MAX(), MAXVALUES(), MIN(), MINVALUES(), MTOS(), PROPER(), SEEK, SEEK(), TYPE(), UPPER(), VARTYPE()
Description
The CONTAINS() function returns .T. (True) if the current record contains the specified character string, <expC>.
A case-insensitive search is performed on the current record's character fields. If the optional <expL> is .T. (True) or the optional <expN> is 1, memo fields are also checked, otherwise they are excluded from the search.
Parameters | Description |
---|---|
<expC> | The character string to search for. Delimit words or phrases with commas |
<expL> | If .T. (True), memos are included in the search. |
<expN> | If 1, memos are included in the search. |
The CONTAINS() function is particularly useful in creating full text-search indexes, as shown in the example below.
Example
open database southwind use products // Restrict index to product records in category 2 (condiments) with a character field containing string "bottled", memos excluded index on lower(productname) for contains("bottles,jars,cans",.F.) and categoryid = 2 tag bottled