Method 1: Using the Instr command...

      Note: Here I've used two separate lines just in case there's more than
            one rider out there with the characters "SUTHERLAN" (without the
            quote characters) as part of the rider name. 

            Leaving the "D" out of the rider name prevents the interface's special 
            handling of "AND" from kicking in.

            Breaking the results out BY RIDER is a good idea as you will then
            know if your query results are based on more than one rider.

  


     Data Window Settings:
     999 Divisor  Odds Cap: None

     SQL:  SELECT * FROM STARTERHISTORY
           WHERE INSTR(RIDER, 'SUTHERLAN') > 0 
           AND INSTR(RIDER, 'CHANTAL') > 0


     Data Summary         Win     Place      Show
     Mutuel Totals     280.60    292.70    298.60
     Bet              -454.00   -454.00   -454.00
     Gain             -173.40   -161.30   -155.40

     Wins                  31        54        85
     Plays                227       227       227
     PCT                .1366     .2379     .3744

     ROI               0.6181    0.6447    0.6577
     Avg Mut             9.05      5.42      3.51


     ****************************************************************************************
     BY RIDER sorted by wins                                 Run Date: 7/16/2010 9:12:19 PM
     ****************************************************************************************
                                            WIN  WIN          WIN               PLACE   PLACE
     UDM              PLAYS    WINS         PCT  IMPACT       ROI  PLACES         PCT     ROI
     ****************************************************************************************
     SUTHERLAND CHANTAL  227     31      0.1366  1.0003    0.6181    54        0.2379  0.6447  
     ****************************************************************************************
     1 Riders from file: StarterHistory Table
     ****************************************************************************************







  Method 2: Using the LIKE command with a % character.

      Note: Here I've used two separate lines just in case there's more than
            one rider out there with the characters "SUTHERLAN" as part of
            the rider name. Leaving the "D" out of the rider name prevents
            the interface's special handling of "AND" from kicking in.

            Breaking the results out BY RIDER is a good idea as you will then
            know if your query results are based on more than one rider.

            The % character acts as a wildcard character. The way it is used below
            causes all of the characters after "SUTHERLAN" (without the quote characters)
            to return a sql match. A sql match is also created for any rider names having
            any set of characters in the name followed by "CHANTAL" (again without the 
            quote characters.

            For a sql tutorial on the use of LIKE and INSTR visit:

	    http://www.w3schools.com/SQl/sql_intro.asp
 

         



     query start:         7/16/2010 9:14:13 PM
     query end:           7/16/2010 9:14:14 PM
     elapsed time:        1 seconds

     Data Window Settings:
     999 Divisor  Odds Cap: None

     SQL:  SELECT * FROM STARTERHISTORY
           WHERE RIDER LIKE 'SUTHERLAN%' 
           AND RIDER LIKE '%CHANTAL'


     Data Summary         Win     Place      Show
     Mutuel Totals     280.60    292.70    298.60
     Bet              -454.00   -454.00   -454.00
     Gain             -173.40   -161.30   -155.40

     Wins                  31        54        85
     Plays                227       227       227
     PCT                .1366     .2379     .3744

     ROI               0.6181    0.6447    0.6577
     Avg Mut             9.05      5.42      3.51


     ****************************************************************************************
     BY RIDER sorted by wins                                 Run Date: 7/16/2010 9:14:14 PM
     ****************************************************************************************
                                            WIN  WIN          WIN               PLACE   PLACE
     UDM              PLAYS    WINS         PCT  IMPACT       ROI  PLACES         PCT     ROI
     ****************************************************************************************
     SUTHERLAND CHANTAL  227     31      0.1366  1.0003    0.6181    54        0.2379  0.6447  
     ****************************************************************************************
     1 Riders from file: StarterHistory Table
     ****************************************************************************************