Stuart McLachlan
stuart at lexacorp.com.pg
Fri Jul 8 17:37:59 CDT 2011
"some*" can use indexes. "*omething" can't On 8 Jul 2011 at 13:24, jwcolby 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? > > -- > John W. Colby > www.ColbyConsulting.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >