SELECT Client.Name FROM Client WHERE Client.NoProvince=@NoProvince AND NOT (Client.NoStatus=@NoStatus AND Client.ModDate<@ModDate)The execution is getting more complex because the usage of NOT. If I remove the NOT, the execution is straight forward. However, this is only for testing purposes as it wouldn't give the same result.