>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.
If it's not broken, fix it until it is.
My Blog 
