$ Operator

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:

  LIST FOR 'FOX' $ UPPER(memo_fld)
  

Return Value

Logical

Remarks

If the character expression is not found, False (.F.) is returned. The $ operator is case-sensitive and is not Rushmore optimizable.

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.

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

Concepts

Using Rushmore Query Optimization to Speed Data Access

Reference

% Operator (Visual FoxPro)

DELETE FILE Command

CREATE TABLE - SQL Command

AT( ) Function

ATLINE( ) Function

RAT( ) Function

RATLINE( ) Function

OCCURS( ) Function

INLIST( ) Function

Operators (Visual FoxPro)