DECLARE @Title Varchar(20) SET @Title='00055%' SELECT Client.FirstName FROM Client WHERE Client.Title LIKE @Title...this will not used the index Client.Title. If I change LIKE for =, it will. Anyone has found a way to avoid a lookup, which is what the execution plan is showing, in such a search? I mean, everything which starts by should be optimized. But, it does not seem to be case.