Hi,
Let's assume I have a table (called tbl) with a column 'name' and an index
on it.
How to optimally find records whose name column begins with - say - "Pre"?
I know it can be done with LIKE (WHERE name LIKE 'Pre%'), but will this use
the index mentioned above to optimize the search?
Thanks,
Otto