<div>
<pre><code class="code-1 nolinks" id="code-20-42070054-1"><span>SELECT *</span>
<span>FROM MyTable</span>
<span>WHERE (CASE WHEN columnA = 'A' AND Status = 'B' AND columnC = 'A1' THEN 0 ELSE 1 END) = 1</span>
</code></pre>
<br />
You can just specify that condition and everything else is &quot;true&quot;, and then limit the results to just records that evaluate to &quot;true&quot;
</div>


<div>
SELECT FROM TabNAme<br />
WHERE columnA &nbsp;= 'A' <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and Status = 'B'<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and ColumnC &nbsp;&lt;&gt; 'A1'
</div>


<div>
E.g.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42070056-1"><span>SELECT T.* </span>
<span>FROM schemaName.tableName T </span>
<span>WHERE NOT (T.columnA = 'A' AND T.Status = 'B') AND NOT columnC = 'A1';</span>
</code></pre>
</div>


<div>
The above condition should only apply for scenario when columnA &nbsp;= 'A' &nbsp;and Status = 'B' not for other values
</div>


<div>
And in that case where does the &quot;...then eliminate records in columnC where ColumnC &nbsp;= &quot;A1&quot; stands? Is that needed or not?<br />
If all needed is indeed &quot;...only apply for scenario when columnA &nbsp;= 'A' &nbsp;and Status = 'B' &quot;&nbsp;then the SELECT would be like:<br />
<br />
SELECT FROM TabNAme<br />
WHERE columnA &nbsp;= 'A' <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and Status = 'B'
</div>


<div>
select * from table<br />
except<br />
select * from table<br />
where columnA = 'A'<br />
and Status = 'B'<br />
and columnC = 'A1'
</div>


<div>
I am using this CASE statement but it is failing<br />
Where ColumnC &lt;&gt;&nbsp;(CASE WHEN &nbsp;ColumnA =&quot;A&quot; AND Status = &quot;B&quot; THEN &quot;A1&quot; ELSE Nothing END)
</div>


<div>
select * from tablename <br />
WHERE ColumnC &lt;&gt;&nbsp;(CASE WHEN &nbsp;ColumnA = 'A' AND [Status] = 'B' THEN 'A1' ELSE NULL END)
</div>


<div>
<div class="content wysiwyg-content">
I have question. I am &nbsp;Pulling my data from SQL DB and I want to exclude particular records from a table. Lets say columnA &nbsp;= &quot;A&quot; and Status = &quot;B&quot; then eliminate records in columnC where ColumnC &nbsp;= &quot;A1&quot;<br />
<br />
How to use a if clause or case clause in where condition?
</div>
</div>


I have question. I am  Pulling my data from SQL DB and I want to exclude particular records from a table. Lets say columnA  = "A" and Status = "B" then eliminate records in columnC where ColumnC  = "A1"

How to use a if clause or case clause in where condition?

Conditions in Where clause

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.