>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.