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

  WILDSEEK:

  The WILDSEEK command functions similarly to the standard Clipper SEEK
  command.  However, as its name implies, you can perform wildcard SEEKs with
  WILDSEEK.  Simply substitute a question mark (?) or an asterisk (*) in
  place of the portion to contain the wildcard portion of the search string.

  For example, to find the first person in your CUSTOMER database whose
  name is either Smith or Smyth, you could do this:

       USE CUSTOMER             // Open CUSTOMER.DBF
       SET TAG TO LASTNAME      // Select LASTNAME Tag
       WILDSEEK "Sm?th"         // or WILDSEEK "Sm*th"
       WHILE found()            // Got at least one!
         ? LAST + ", " + FIRST  // Display customer name
         WILDSEEKNEXT "Sm?th"   // Look for next match
       ENDDO


  As with the standard SEEK command, Clipper's found() function will let
  you know if WILDSEEK successfully found a matching record.

  You can also perform WILDSEEKs where the wildcard character at the
  beginning of the search string (i.e.; WILDSEEK "*son").  However, keep
  in mind that since WILDSEEK has no idea what the first letter might be, it
  must start at the top of the database and SKIP through each record looking
  for a match.  This can take just as long as using Clipper's standard
  LOCATE command.

    NOTE:  This command is NOT supported under SIXNTX.