CONTAINS()

From Lianjapedia
Revision as of 09:25, 20 September 2016 by Yvonne.milne (Talk | contribs)

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

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