<div>
<pre><code class="code-1 nolinks" id="code-20-43049847-1"><span>select *</span>
<span>from notes</span>
<span>where bl_notes_text like '%MEDIA%' </span>
<span>  AND bl_notes_text NOT like '%Social Media%'</span>
</code></pre>
</div>


<div>
oh, that simple! i thought I would have to do something tricky!<br><br>Thank you I will test it out now!!
</div>


<div>
Just a note - If MEDIA is always in caps and Social Media is always in initial caps, then where bl_notes_text like '%MEDIA%' will automatically exclude Social Media.
</div>


James Murphy

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
Firstly thank you for taking the time to look at my question - your help is invaluable!<br />
<br />
What I need to do, is a ms SQL (MS SQL server 2017) query, that does a like, but I need it to exclude certain instances.<br />
<br />
ie i know this:<br />
select *<br />
from notes<br />
where bl_notes_text like '%MEDIA%' <br />
<br />
but I need it to exclude '%Social Media%'<br />
<br />
how would I go about this?<br />
<br />
many thanks!!
</div>
</div>


Hi Experts,

Firstly thank you for taking the time to look at my question - your help is invaluable!

What I need to do, is a ms SQL (MS SQL server 2017) query, that does a like, but I need it to exclude certain instances.

ie i know this:
select *
from notes
where bl_notes_text like '%MEDIA%' 

but I need it to exclude '%Social Media%'

how would I go about this?

many thanks!!

query using like,  but excluding certain instances of that like

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.

Microsoft SQL Server

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.