DECLARE @Name varchar(20) DECLARE @Name2 varchar(20) DECLARE @ID integer set @Name = 'A301041%' set @Name2 = 'A301041%' set @ID = 1 SELECT Client.Numero FROM Client WHERE (Client.Name LIKE @Name OR Client.Name2 LIKE @Name2) AND Client.ID=@IDThis depends on the value entered. However, if I am not going parameterized, no matter the value, I will always get an optimized search result. But, for certain values, when going parameterized, it can take up to 8 to 50 seconds to find the same query.