DECLARE @NoEntity Int DECLARE @VehicleMake Varchar(30) DECLARE @VehicleModel Varchar(30) SET @NoEntity=19 SET @VehicleMake='VOLKSWAGEN%' SET @VehicleModel='"CABRIOLET*"' SELECT Client.PrimaryKey FROM Client (NOLOCK) WHERE Client.NoEntity=@NoEntity AND Client.VehicleMake LIKE @VehicleMake AND Contains (Client.VehicleModel, @VehicleModel) -- time 1 ? SELECT Client.PrimaryKey FROM Client (NOLOCK) WHERE Client.NoEntity=19 AND Client.VehicleMake LIKE 'VOLKSWAGEN%' AND Contains (Client.VehicleModel, '"CABRIOLET*"') -- time 2 ?post time 1 and time 2.