CFQuery LIKE on NULL values

I’ve got this query of query: [code=“sql”] SELECT * FROM qSectionArticles WHERE displays LIKE ‘%publications%’ [/code]

This code was returning a CF error:

It turns out the problem was that I the column that I am querying for (displays column) has a NULL value assigned to it, luckily there are only 5 or so entries in this table, so I can just quickly fill them with values and change the field to not allowing NULL as well as giving it a default value (the database is SQL Server 2000 by the way)