<div>
<br />
You must use OR<br />
<br />
using AND implies that the a filed must satisfy both conditions ie (id like 'aaa' and id like 'bbb') which is not possible<br />
<br />
The only time and would be true in your case is if you had a record with id 'aaabbb' <br />
Then in this case both conditions match this value Like %aaa% and Like %bbb%
</div>


<div>
I want to be able to use OR and And. How can i do this? OR works very well for me.
</div>


<div>
Thanks. Very helpful and works for me.
</div>


<div>
<div class="content wysiwyg-content">
I have a sql table with two records. Please look at the attached Image. <br />
<br />
I want to be able to test every field for a particular value. If I run the query below<br />
<br />
select value1,value2,value3 from tester2 <br />
where value1 like &nbsp;'%'+ 'aaa' + '%' or value2 like &nbsp;'%'+ 'aaa' + '%' or value3 like &nbsp;'%'+ 'aaa' + '%'<br />
And (value1 like &nbsp;'%'+ 'bbb' + '%' or value2 like &nbsp;'%'+ 'bbb' + '%' or value3 like &nbsp;'%'+ 'bbb' + '%')<br />
<br />
My query returns<br />
<br />
&nbsp; &nbsp;value1 &nbsp; value2 &nbsp; &nbsp;value3<br />
<br />
1 &nbsp;aaa &nbsp; &nbsp; &nbsp; &nbsp;null &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;null <br />
<br />
<br />
This is wrong because &nbsp;I only have one entry of aaa and another of bbb. I dont have a situation where both aaa and bbb exists for a record. How can I correct this? <br />
If i use or instead of the And, it works very well. &nbsp;<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/03_w11/417727/sampleTable.png" target="_blank" title="sample sql table (4 KB)"><img alt="sample sql table" class="file-block lazyload" style="max-width: 365px;" data-src="https://filedb.experts-exchange.com/incoming/2011/03_w11/417727/sampleTable.png" /></a> 
</div>
</div>


sampleTable.png

I have a sql table with two records. Please look at the attached Image. 

I want to be able to test every field for a particular value. If I run the query below

select value1,value2,value3 from tester2 
where value1 like  '%'+ 'aaa' + '%' or value2 like  '%'+ 'aaa' + '%' or value3 like  '%'+ 'aaa' + '%'
And (value1 like  '%'+ 'bbb' + '%' or value2 like  '%'+ 'bbb' + '%' or value3 like  '%'+ 'bbb' + '%')

My query returns

   value1   value2    value3

1  aaa        null          null 


This is wrong because  I only have one entry of aaa and another of bbb. I dont have a situation where both aaa and bbb exists for a record. How can I correct this? 
If i use or instead of the And, it works very well.  

 


You must use OR

using AND implies that the a filed must satisfy both conditions ie (id like &#39;aaa&#39; and id like &#39;bbb&#39;) which is not possible

The only time and would be true in your case is if you had a record with id &#39;aaabbb&#39; 
Then in this case both conditions match this value Like %aaa% and Like %bbb%

I want to be able to use OR and And. How can i do this? OR works very well for me.

Using  &#39;And&#39;   to get result of matching data in sql table

I have a sql table with two records. Please look at the attached Image. 

I want to be able to test every field for a particular value. If I run the query below

select value1,value2,value3 from tester2 
where value1 like  &#39;%&#39;+ &#39;aaa&#39; + &#39;%&#39; or value2 like  &#39;%&#39;+ &#39;aaa&#39; + &#39;%&#39; or value3 like  &#39;%&#39;+ &#39;aaa&#39; + &#39;%&#39;
And (value1 like  &#39;%&#39;+ &#39;bbb&#39; + &#39;%&#39; or value2 like  &#39;%&#39;+ &#39;bbb&#39; + &#39;%&#39; or value3 like  &#39;%&#39;+ &#39;bbb&#39; + &#39;%&#39;)

My query returns

   value1   value2    value3

1  aaa        null          null 


This is wrong because  I only have one entry of aaa and another of bbb. I dont have a situation where both aaa and bbb exists for a record. How can I correct this? 
If i use or instead of the And, it works very well.  

 

Using  'And'   to get result of matching data in sql table

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.