where isnull(column_name, '') not like '%somevalue%' works for me. when I want to include NULL as a default in the results, converting it to a blank char allows the evaluation.