How to Browse for a Specific Character String

ID: Q88617

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.0, 2.5x, 2.6, 2.6a
Microsoft FoxPro for Windows, versions 2.5x, 2.6, 2.6a
Microsoft FoxPro for Macintosh, versions 2.5x, 2.6a

To browse a database field for a specific string, use the $ operator.

For example, to browse the customer database and find all records in which the COMPANY field contains the string "computer" regardless of case, use the following command:

   BROWSE FOR "COMPUTER" $ UPPER(COMPANY)

This command also works if the string to search for is in a variable. For example:

   x="computer"
   BROWSE FOR UPPER(x) $ UPPER(COMPANY)

Additional reference words: FoxDos FoxWin FoxMac 2.00 2.50 2.50a 2.50b 2.50c 2.60 2.60a KBCategory: kbprg KBSubcategory: FxprgBrowse

Last Reviewed: June 27, 1995