>In this WHERE clause, I have parentheses:
>
>

>WHERE Client.NoProvince=@NoProvince AND
> NOT (Client.Status<@Status AND Client.NoStatus=@NoStatus) AND
> NOT (Client.Status<@Status2 AND Client.NoStatus=@NoStatus2) AND
> NOT (Client.Status<@Status3 AND Client.NoStatus=@NoStatus3) AND
> NOT (Client.Status<@Status4 AND Client.NoStatus=@NoStatus4) AND
> Client.NoCountry IN (1,2,3,4,5,6,7) AND
> Client.FirstName LIKE @LXList1Clm_No
>

>
>Would there be a way to avoid the parentheses? I see the execution is much smarter without those.

So, can you translate these conditions into English? Is it the same as

When NoStatus = @NoStatus you want rows with Status >=@Status
for NoStatus = @NoStatus1 you want rows with Status >=@Status1

etc.

If my interpretation is correct and NoStatus can only be one of the 4 statuses, then you can convert this condition into CASE based.

1 = case Client.NoStatus when @NoStatus
then case when Client.Status >= @Status then 1 else 0 end
when @NoStatus1
then case when Client.Status >= @Status1 then 1 else 0 end
etc.
end