<div>
AND (<br />
(typeid=1 OR Isnull(m.member,'FALSE')='<wbr />TRUE') -- one of<br />
OR<br />
-- rest of clause
</div>


AND (
(typeid=1 OR Isnull(m.member,'FALSE')='TRUE') -- one of
OR
-- rest of clause

<div>
Thanks.<br />
<br />
Worked fine once implemented.
</div>


<div>
<div class="content wysiwyg-content">
Hello I have the following code in my WHERE clause<br />
<br />
AND <br />
(<br />
&nbsp; &nbsp; &nbsp;ISNULL(m.Member,'FALSE') = 'TRUE'<br />
&nbsp; &nbsp; &nbsp;OR<br />
&nbsp; &nbsp; &nbsp;(<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ISNULL(vc.Amount,0) != 0<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND vc.VoluntaryContributionTy<wbr />peID = @contribtuionTypeID<br />
&nbsp; &nbsp; &nbsp;)<br />
)<br />
<br />
This works really well. However I've now been giving some additional requirements and I'm ot sure how to make the SQL work.<br />
<br />
If a varialbe called TypeID (not shown in above code) is = 1, then I don't want the clause to evaluate this portion:<br />
<br />
ISNULL(m.Member,'FALSE') = 'TRUE'<br />
<br />
So if TypeID is 1, I don't care about the n.Member field, if it is not 1, I do care.<br />
<br />
Any easy way to write that statement?<br />

</div>
</div>


Hello I have the following code in my WHERE clause

AND 
(
     ISNULL(m.Member,'FALSE') = 'TRUE'
     OR
     (
          ISNULL(vc.Amount,0) != 0
          AND vc.VoluntaryContributionTypeID = @contribtuionTypeID
     )
)

This works really well. However I've now been giving some additional requirements and I'm ot sure how to make the SQL work.

If a varialbe called TypeID (not shown in above code) is = 1, then I don't want the clause to evaluate this portion:

ISNULL(m.Member,'FALSE') = 'TRUE'

So if TypeID is 1, I don't care about the n.Member field, if it is not 1, I do care.

Any easy way to write that statement?


Using CASE in WHERE Clause

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.