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

Thanks, this provides valuable information.

If you look at Message #1610467, you will see a more realistic command I have to execute.

Based on your reply, from that referred message, does this mean the second command, the one without the NOT clauses, wouldn't need any parentheses?