>>Is there a way to Rushmore optimize a LIKE() function when used in WHERE clause of a Select statement?
>
>Use LIKE instead. If you use MyField LIKE 'SomeValue%' it will be optimized. If you start with '%' it is not going to be optimized.
Thanks, I forgot thar vfp allows that syntax in sql.
Greg Reichert