js editor
Web development
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 CodeLIST 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.
| В | 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 | |