Select * From tabella Where not(campo_1 Like '%ciao%')
Select * From tabella Where campo_1 not Like '%ciao%'