<div>
Have you tried the LIKE operator:<br />
<br />
WHERE colname LIKE '%a%' or colname LIKE '%b%'
</div>


Have you tried the LIKE operator:

WHERE colname LIKE '%a%' or colname LIKE '%b%'

<div>
Hi,<br />
Problem is it isn't in a table, its values i've copied into a list (a,b etc) from XL.<br />
Hence why i'm trying to use IN ()<br />
Cheers,<br />
Brett
</div>


Hi,
Problem is it isn't in a table, its values i've copied into a list (a,b etc) from XL.
Hence why i'm trying to use IN ()
Cheers,
Brett

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a text list to use with IN operator - IN ('a','b') yet i need to compare it to a field that might contain the value of a;b so i want to put wild cards in the IN list??? Doesn't seem to work - ie:<br />
<br />
WHERE IN ('%a%' , &nbsp;'%b%')<br />
<br />
Any other way to achieve this without importing text files to table etc?<br />
<br />
Cheers,<br />
Brett
</div>
</div>


Hi,

I have a text list to use with IN operator - IN ('a','b') yet i need to compare it to a field that might contain the value of a;b so i want to put wild cards in the IN list??? Doesn't seem to work - ie:

WHERE IN ('%a%' ,  '%b%')

Any other way to achieve this without importing text files to table etc?

Cheers,
Brett

Using IN and LIKE Operator together Oracle SQL %

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.