Difference between revisions of "CONTAINS()"

From Recital Documentation Wiki
Jump to: navigation, search
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

Template:YLM to do

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