[AccessD] Indexes on text fields

Mark Whittinghill mwhittinghill at symphonyinfo.com
Thu Aug 14 16:22:21 CDT 2003


Cool, thanks.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
----- Original Message ----- 
From: "Martin Reid" <mwp.reid at qub.ac.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, August 15, 2003 12:01 AM
Subject: Re: [AccessD] Indexes on text fields


> I have passed it to a contact at MS. When he replies I will forward the
> response.
>
> Martin
>
>
> ----- Original Message ----- 
> From: "Mark Whittinghill" <mwhittinghill at symphonyinfo.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Thursday, August 14, 2003 1:23 PM
> Subject: Re: [AccessD] Indexes on text fields
>
>
> > Martin,
> >
> >   Let's say I have a Person table with Indexes on FirstName and
LastName.
> > In my query, I have a field FullName: LastName & ", " & FirstName.  Will
> the
> > indexes on these two fields have any effect on sorts and searches on
> > FullName?  I could see throwing in FirstName and LastName as sorts in
the
> > query definition, but what about cases where I want to do a LIKE search
on
> > FullName?
> >
> > Thanks,
> >
> > Mark Whittinghill
> > Symphony Information Services
> > 612-333-1311
> > mwhittinghill at symphonyinfo.com
> > ----- Original Message ----- 
> > From: "Martin Reid" <mwp.reid at qub.ac.uk>
> > To: "Access Developers discussion and problem solving"
> > <accessd at databaseadvisors.com>
> > Sent: Thursday, August 14, 2003 11:07 PM
> > Subject: Re: [AccessD] Indexes on text fields
> >
> >
> > > Someone send the origonal question and I will pass it on to someone
whoh
> > > knows.
> > >
> > > Martin
> > >
> > >
> >
> >
> > _______________________________________________
> > 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
>




More information about the AccessD mailing list