1886 Lynwood Drive/Concord, CA 94519
Telephone: (415) 735-7504

---

Wild Cards
Wild Cards Can Not Be Used in Numberic or Logical Fields


Character       Meaning 
   ?            In a charactger field, matches any single character
                in the same position in the field.

                Example:
                X?Z would match both XYZ and XXZ but not X6Z

   *            In a character field, matches any group of characgters
                (including no characters).

                Example:
                X*Z would batch XYZ, XXZ and X6Z

                In a date query, matches any value in that part of the
                date (for example, 12/*/2005 matches any day in 2005.

   @            In a date query, matches any value that corresponds to
                that part of the system date (for example, @/*/2005
                matches any day in 2005 in the month that is the current
                system month)