WHERE Client.NoProvince=@NoProvince AND NOT (Client.Status<@Status AND Client.NoStatus=@NoStatus) AND NOT (Client.Status<@Status2 AND Client.NoStatus=@NoStatus2) AND NOT (Client.Status<@Status3 AND Client.NoStatus=@NoStatus3) AND NOT (Client.Status<@Status4 AND Client.NoStatus=@NoStatus4) AND Client.NoCountry IN (1,2,3,4,5,6,7) AND Client.FirstName LIKE @LXList1Clm_NoWould there be a way to avoid the parentheses? I see the execution is much smarter without those.