interest of indexes ....

Hello,

An index works for search of the complete string of the field but is it appropiated for the substring search too

For ex. I would like to know if an index on phone field is appropriated in this case

SELECT * From Contact WHERE phone like '%0867%';

Thanks
Fred Received on Mon Jun 17 2002 - 08:13:26 CDT