>>select Name from dbo.Client >>where NoProvince = @NoProvince and (NoStatus <> @NoStatus OR ModDate >=@ModDate)>
NOT ( A and B) is NOT(A) or NOT(B)So
NOT (Client.NoStatus=@NoStatus AND Client.ModDate<@ModDate) NOT( Client.NoStatus=@NoStatus ) OR NOT(Client.ModDate<@ModDate) is (Client.NoStatus <> @NoStatus) OR ( Client.ModDate>= @ModDate )Also
NOT ( A or B) is NOT(A) and NOT(B)