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