Click above to get retro games delivered to your door ever month!

  With the Contains ( $ ) Operator

  Using the contains operator you can optimize queries on a single
  field with a list of items.  In order to be optimized the query must
  take on the form of the examples below.

       COUNT TO nCount FOR State $ "CA,NC,FL,SC,IL,GA"

       COPY TO Temp FOR PayType $ "CASH CHCK CRED"

  The field must be listed to the left of the "$" and the list ( or
  string ) must be greater than or equal to the width of the field.
  Queries like the following are not optimizable.

         SUM Amount TO nAmount FOR "S" $ Last

  Note that the items in the "list" need not be delimited with a common
  character.  The "," and " " were placed in the string to prevent
  erroneous matches.  The following is an example of a query using a
  single character indexed field DEBTCODE that is optimizable without
  specifying any delimiters.

        COUNT TO nCount FOR  DebtCode $ "ABCDEFG"

  If there is ever a question whether a query condition is optimizable,
  check its optimization level with the m6_IsOptimize() function.