Searching for a Series of Matches in a Field for a Report

ID: Q107802

The information in this article applies to:

• Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b
• Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, and 2.5b

You can output different matches in the same field by either issuing a FOR clause or using the INLIST() function. For example:

   REPORT FORM <file> FOR fname = "George" or fname = "Mike"

   -or-

   REPORT FORM <file> FOR INLIST(fname,"George","Mike")

NOTE: The INLIST() function can search for up to 24 sets of expressions. However, you may not be able to use 24 sets of expressions because of the 254-character limit on the command line.