[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
>