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