>>NOT ( A and B) >> >>is >> >>NOT(A) or NOT(B) >> >>>>
>>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 ) >> >>>>
>>NOT ( A or B) >>is >>NOT(A) and NOT(B) >>>
SELECT Client.Numero FROM Client (NOLOCK) WHERE (Client.ModDate>=@ModDate OR Client.NoStatus<>@NoStatus) AND (Client.ModDate>=@ModDate2 OR Client.NoStatus<>@NoStatus2) AND (Client.ModDate>=@ModDate3 OR Client.NoStatus<>@NoStatus3)without parentheses would be
SELECT Client.Numero FROM Client (NOLOCK) WHERE Client.ModDate>=@ModDate OR Client.NoStatus<>@NoStatus AND Client.ModDate>=@ModDate2 OR Client.NoStatus<>@NoStatus2 AND Client.ModDate>=@ModDate3 OR Client.NoStatus<>@NoStatus3and is the same as
SELECT Client.Numero FROM Client (NOLOCK) WHERE Client.ModDate>=@ModDate OR ( Client.NoStatus<>@NoStatus AND Client.ModDate>=@ModDate2) OR (Client.NoStatus<>@NoStatus2 AND Client.ModDate>=@ModDate3 ) OR (Client.NoStatus<>@NoStatus3)which is different