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
