Difference between revisions of "CONTAINS()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to perform a case-insensitive search of a record's character and memo (optional) fields for a specified character string | Function to perform a case-insensitive search of a record's character and memo (optional) fields for a specified character string | ||
| − | |||
==Syntax== | ==Syntax== | ||
CONTAINS(<expC>,[<expL>|<expN>]) | CONTAINS(<expC>,[<expL>|<expN>]) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[BETWEEN()]], [[CHROVERLAP()]], [[EMPTY()]], [[EVALUATE()]], [[EXPRCHECK()]], [[FOR()]], [[INDEX]], [[INLIST()]], [[INRANGE()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[LOWER()]], [[MAX()]], [[MAXVALUES()]], [[MIN()]], [[MINVALUES()]], [[MTOS()]], [[PROPER() | + | [[BETWEEN()]], [[CHROVERLAP()]], [[EMPTY()]], [[EVALUATE()]], [[EXPRCHECK()]], [[FOR()]], [[INDEX]], [[INLIST()]], [[INRANGE()]], [[ISALPHA()]], [[ISBLANK()]], [[ISDIGIT()]], [[LOWER()]], [[MAX()]], [[MAXVALUES()]], [[MIN()]], [[MINVALUES()]], [[MTOS()]], [[PROPER()]], [[SEEK]], [[SEEK()]], [[TYPE()]], [[UPPER()]], [[VARTYPE()]] |
| − | + | ||
==Description== | ==Description== | ||
| Line 15: | Line 12: | ||
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. | 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. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 27: | Line 23: | ||
|- | |- | ||
|} | |} | ||
| − | |||
The CONTAINS() function is particularly useful in creating full text-search indexes, as shown in the example below. | The CONTAINS() function is particularly useful in creating full text-search indexes, as shown in the example below. | ||
| − | |||
==Example== | ==Example== | ||
| Line 40: | Line 34: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 13:08, 10 February 2012
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(), 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. |
| <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",.F.) and categoryid = 2 tag bottled
