[AccessD] Help with SQL Criteria

I figured it out. There were 2 spaces at the front of the record (sigh).
like "  American Express*" worked great. Thanks
Jim H

-----Original Message-----
From: jeffrey.demulling at usbank.com [mailto:jeffrey.demulling at usbank.com]
Sent: Wednesday, May 26, 2004 11:29 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Help with SQL Criteria



Like "American Express*"


 

                      "Hale, Jim"

                      <Jim.Hale at fleetpride.com>        To:       "Access
Developers discussion and problem solving"                            
                      Sent by:
<accessd at databaseadvisors.com>

                      accessd-bounces at databasea        cc:

                      dvisors.com                      Subject:  [AccessD]
Help with SQL Criteria                                              
 

 

                      05/26/2004 11:19 AM

                      Please respond to "Access

                      Developers discussion and

                      problem solving"

 

 





I have records with a description field. A number of records start with "
American Express" followed by different codes. I can't remember how to
structure the criteria to find the records which start with American
express. Some combination with the like operator I presume. Any help would
be appreciated.
Jim Hale
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com