Avatar of James Murphy
James Murphy
Flag for Australia

asked on 

query using like, but excluding certain instances of that like

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!!
Microsoft SQL ServerSQL

Avatar of undefined
Last Comment
Pavel Celba

8/22/2022 - Mon