Returns True (.T.) if a character expression is contained in another character expression; otherwise, returns False (.F.).

cSearchFor $ cSearchIn

Parameters

cSearchFor

Specifies the expression looked for within cSearchIn.

cSearchIn

Specifies the expression that is searched to see if it contains cSearchFor.

If cSearchFor is found in cSearchIn, $ returns True (.T.); otherwise, it returns False (.F.). cSearchFor and cSearchIn can be character-type variables or array elements, character-type fields, character string literals, or memo fields of any length.

Memo fields can be manipulated like character expressions, fields in tables, variables, or array elements. For example, if MEMO_FLD is a memo field, the following is acceptable:

	Copy Code
LIST FOR 'FOX' $ UPPER(memo_fld)

Return Value

Remarks

Example

The following example creates a table called memotest containing one memo field. Three records are appended to the table. LIST is used to display the three records. The dollar sign ($) is used to list the records that contain the string "FOX". The files created for the example are then deleted.

	Copy Code
CLOSE DATABASES CLEAR CREATE TABLE memotest (Text C(3), Memo M) INSERT INTO memotest (Text, Memo) VALUES ('Fox', 'Fox') INSERT INTO memotest (Text, Memo) VALUES ('Cat', 'Cat') INSERT INTO memotest (Text, Memo) VALUES ('FOX', 'FOX') LIST FIELDS Memo, Text FOR 'FOX' $ UPPER(Memo) USE DELETE FILE memotest.dbf DELETE FILE memotest.fpt

See Also