[AccessD] xyz* faster than *asd

I don't think that is true Arthur.

If testing Like XYZ* you are saying ONLY THINGS THAT begin with XYZ, and if
testing LIKE *XYZ you are saying only things which end with XYZ 



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, July 08, 2011 1:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] xyz* faster than *asd

Well yeah! If prefaced with an asterisk, it means LIKE everything; if
suffixed with an asterisk, it means "Everything like JWC*"; hence search for
JWC and walk the remaining similarities.

A.

On Fri, Jul 8, 2011 at 1:24 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:

> Does anyone know of a reason that LIKE is faster with the * in back 
> instead of the front of a string to search by in the where clause?
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com