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