[AccessD] xyz* faster than *asd

 > Well yeah! If prefaced with an asterisk, it means LIKE everything;

AFAIK they mean the same thing (only backward)

*asd means everything with 'asd' at the end
asd* means everything with 'asd' at the beginning

I vaguely remember reading (long ago) that one was faster than the other but the why escapes me.

John W. Colby
www.ColbyConsulting.com

On 7/8/2011 1:47 PM, Arthur Fuller wrote:
> 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?
>>
>>