[AccessD] Help with SQL Criteria

have you tried:  Like "*American Express*"

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Hale, Jim
Sent: Wednesday, May 26, 2004 1:48 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Help with SQL Criteria


Thanks. That is what i thought but no joy. There is a space as the first
character of each record if that makes any difference.
Jim

-----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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com