Charlotte Foust
charlotte.foust at gmail.com
Sat Jul 9 22:16:17 CDT 2011
Because an ampersand at the front means the entire recordset has to be examined. The ampersand at the back means the records that don't match the initial letters don't need to be examined at all. Charlotte Foust -- Sent from my Android phone with K-9 Mail. Please excuse my brevity. 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? -- John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com