How is it possible to use Index Seek for LIKE %search-string% case?

To be more precise, how Index Seek can be used in case LIKE %search-string% case. I expected that ONLY Index Scan operation can be used here

That is correct, such a an "contains" pattern search an index can't be used by the engine, therefore always an index/table scan is performed.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]