>I think the second statement needs parentheses. Without, the ANDs will be executed before the ORs
>
>http://msdn.microsoft.com/en-us/library/ms190276.aspx
>
>Your statement
>

>SELECT Client.Numero FROM Client (NOLOCK)
> WHERE (Client.ModDate>=@ModDate OR Client.NoStatus<>@NoStatus) AND
>  (Client.ModDate>=@ModDate2 OR Client.NoStatus<>@NoStatus2) AND
>  (Client.ModDate>=@ModDate3 OR Client.NoStatus<>@NoStatus3)
>

>
>without parentheses would be
>

>SELECT Client.Numero FROM Client (NOLOCK)
> WHERE Client.ModDate>=@ModDate OR Client.NoStatus<>@NoStatus AND
>  Client.ModDate>=@ModDate2 OR Client.NoStatus<>@NoStatus2 AND
>  Client.ModDate>=@ModDate3 OR Client.NoStatus<>@NoStatus3
>

>
>and is the same as
>
>

>SELECT Client.Numero FROM Client (NOLOCK)
> WHERE Client.ModDate>=@ModDate 
>      OR ( Client.NoStatus<>@NoStatus AND  Client.ModDate>=@ModDate2)
>     OR (Client.NoStatus<>@NoStatus2 AND  Client.ModDate>=@ModDate3 )
>    OR (Client.NoStatus<>@NoStatus3)
>

>
>which is different

Thanks