If I have a search like this:

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.