>>

>>WHERE Client.NoProvince=@NoProvince AND (Client.NoStatus<>@NoStatus OR Client.ModDate>=@ModDate)
>>

>
>I cannot understand how this would be the same.

NOT (A OR B) --> NOT A AND NOT B
NOT (A AND B) --> NOT A OR NOT B