Is it possible to have indexes for like '%*%' type queries Now for my thesis project i need to make a lot of queries like the below

select * from tblMyTable where ItemName like '%item%'


Now my question : is that possible to create indexes for such queries ? If so what is the way of doing it ? Thank you.
For LIKE queries this is not available.

But for making such queries SQL Server provides functionality called Full-text search. More info in MSDN.