>>You can reverse last condition, e.g.
>>

>>select Name from dbo.Client
>>where NoProvince = @NoProvince and (NoStatus <> @NoStatus OR ModDate >=@ModDate)

>
>Yes, this is exactly what Sergey provided as information.
>
>I just do not understand how this provides the same result set. I see it is. It is just a question of knowing how can this be the same.

It's boolean algebra

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)